No announcements
-
0 VotesCouldn't Microsoft develop an application to list all Accelerator Keys for Excel?
I am reading about Accelerator Tables and it looks like it would be easy for the right ...
-
0 Votes
Excel locking up in pivot table manipulation
Addons are disabled. Excel completely locks up when trying to manipulate pivot tables that are ~20mb. Nothing is left in logs as it stops responding. Anyone have any ideas on how to fix it? -
2 Votes
Auto-Running Macros on Open
I have an excel workbook that often gets data added to it. I have a Macro built in to the workbook that does a Save-As and saves it as a text file. Whenever I open the workbook and run the macro it ...Answered | 4 Replies | 16 Views | Created by Acreed02 - 5 hours 13 minutes ago | Last reply by Acreed02 - 3 hours 47 minutes ago -
0 Votes
IFS Formulae now showing up as _xlfn.IFS
Hello All, I am using Excel 2016, since few days, I am not able to use IFS formulae in my excel sheet. the formulae is now replaced with _xlfn.IFS and things are not working fine as ... -
0 Votes
A search box to search for a worksheet in Excel
Hi, Can anyone let me know how to create a search box which would search for a certain worksheet and display that particular sheet in Excel file? Say I've like 45 worksheets and ... -
0 Votes
How to search for patterns in Excel?
so i have a spreadsheet that contains rows of folder path like ...Answered | 2 Replies | 28 Views | Created by Reno Mardo - 12 hours 25 minutes ago | Last reply by Emi Zhang - 9 hours 48 minutes ago -
0 Votes
Excel 2016 online Error Id: e1ebe361-90ae-4a91-8286-9ab2ad714f19, 2018-08-09 07:57:50Z
Excel Online Sorry, something went wrong. Could you please try that again? Give ...Unanswered | 5 Replies | 59 Views | Created by STMutsena - Monday, August 13, 2018 10:31 AM | Last reply by Emi Zhang - 10 hours 44 minutes ago -
2 Votes
Cannot insert hyperlink into Excel cell
Right-clicking on a cell and selecting Hyperlink opens the usual dialog box to allow selection of a file to link, but the OK button in the dialog box is greyed-out. Clicking on a file in ...Proposed | 6 Replies | 3863 Views | Created by WMDG - Tuesday, September 19, 2017 1:07 PM | Last reply by displaynamedammit - 11 hours 26 minutes ago -
0 Votes
Timeline filter options grayed out when sheet is protected
Hello I have a Timeline on a Dashboard. When I protect the sheet, the Timeline filter options i.e. Year, Qtr, Month are not accessible. I have added VBA ...Unanswered | 3 Replies | 31 Views | Created by 123gillyd - Wednesday, August 15, 2018 6:23 PM | Last reply by Emi Zhang - 11 hours 32 minutes ago -
0 Votes
Vlookup on various sheets
Hi, I'm trying to put a formula for eg. product code "ER45A2133440360" which is similar to the manufacturer ...Unanswered | 1 Replies | 52 Views | Created by Bhutia - Wednesday, August 15, 2018 4:19 PM | Last reply by Simon Li - [MSFT] - 12 hours 22 minutes ago -
0 Votes
Excel 2013 randomly changes row height to 409.5 pixels
So as I said, i open a file, and some of the rows are of the maximum possible height. For no reason. If a colleague of mine opens the same document on his/her laptop, there is no issue. This also ...Unanswered | 3 Replies | 1445 Views | Created by Totes Magots - Tuesday, February 25, 2014 12:33 PM | Last reply by Ivanips - 15 hours 30 minutes ago -
0 Votes
Excel 2016 not recognizing currency amounts as numbers
Hi I have Office 365 Solo (the Japan version) installed in an iMac and MacBook, both with El Capitan. When I type numbers with dollar or euro signs into Excel for Mac 2016 ...Answered | 4 Replies | 106 Views | Created by TechNetSolution1 - Thursday, August 2, 2018 10:17 PM | Last reply by TechNetSolution1 - 17 hours 43 minutes ago -
0 Votes
Doubts on formulas of sumproduct with offset, with multiple criteria containing certain piece of text
Hello people. I have ready many articles about sumproduct with multiple criteria (including criteria related to contain certain piece of text) but I could not really find the solution to my ...Unanswered | 3 Replies | 107 Views | Created by Jorge Barbi Martins - Wednesday, August 8, 2018 1:02 PM | Last reply by Herb Gu - 17 hours 45 minutes ago -
0 Votes
Multiple Pie Charts from one pivot table
This question was previously raised with no signs of an answer or solution. I'd like to bring this back up to surface. Hello Excel ...Proposed | 3 Replies | 77 Views | Created by PBD211 - Wednesday, August 8, 2018 7:46 PM | Last reply by Herb Gu - 18 hours 38 minutes ago -
0 Votes
0365 Information Rights Management error
I have a user who is unable to access an Excel file from a shared drive location. She said she emailed the file from the shared location and has since been unable to open or access said ...Proposed | 3 Replies | 110 Views | Created by 007ME - Thursday, August 2, 2018 6:54 PM | Last reply by Herb Gu - 18 hours 44 minutes ago -
0 Votes
Why does iferror not work?
I used a formula : iferror(c1/a1,0) in Excel 2007 and it works fine. Entering the same formula in Excel 2016 I get a reminder/asked if I know I am entering a formula as it starts ...Proposed | 4 Replies | 116 Views | Created by MJKRSA - Thursday, August 2, 2018 8:51 AM | Last reply by Herb Gu - 18 hours 45 minutes ago -
0 Votes
Excel- Personal Expenses Calculator Date Slicer
Hi, I'm using the Personal Expenses Calculator template for Microsoft Excel 2013, and when I entered my information in the expenses log, the date slicer on the expenses ...Proposed | 3 Replies | 126 Views | Created by Shel MF - Wednesday, August 1, 2018 9:05 PM | Last reply by Herb Gu - 18 hours 45 minutes ago -
0 Votes
Pivot, column "groups" to rows
So, here's a weird one. I have a pivot table that shows business units in rows, and then in columns by month cases, revenue and margin, each with its own total - so 39 columns of values. ...Proposed | 7 Replies | 108 Views | Created by Corey Furman - Friday, August 10, 2018 5:31 PM | Last reply by Herbert Seidenberg - 23 hours 9 minutes ago -
0 Votes
Sunburst Chart Data Mapping
I am trying to create a Sunburst chart that will associate a specific color with a specific number. In the example created I have used a Vlookup to map a ...Unanswered | 3 Replies | 99 Views | Created by Disgratz - Monday, August 13, 2018 12:49 PM | Last reply by Disgratz - Wednesday, August 15, 2018 5:43 PM -
0 Votes
Counting unique record up
I have a table with 6 columns and I want to add a formula in H2 to count the number of uniques records in column $D$1: D2 (D3, D4, D5, ..... something like D1 - Pen ...Unanswered | 6 Replies | 89 Views | Created by FSalgueiro - Tuesday, August 14, 2018 9:47 PM | Last reply by FSalgueiro - Wednesday, August 15, 2018 1:29 PM - Items 1 to 20 of 12516 Next ›
No announcements
