Forum

I see what you mean. I have no idea why you are chasing around cells 🙂 Why don't you use the same name from the same table, in both GETPIVOT fo...

I assumed that you know how to handle absolute and relative range references. Here is a link that may help you understand that: excel-2007-absolute...

Hi, This is your formula: =IFERROR(GETPIVOTDATA("Total Cost",$A$6,"Fiscal Quarter","2016 Q 1","SRAccountName",$A$8:$A$100)/GETPIVOTDATA("USD Amo...

Hi, A pivot chart will not display the grand total. You can try using GETPIVOTDATA formula to extract the grand totals from the pivot table and use th...

Or this version:

Hi Cindy, Can you please upload a sample file? Thanks

Hi Libby, As Mynda said, many excel formulas cannot be replicated in the same way. You have to find a different way of thinking in Power Query, ...

Hi Libby, The sample file was very helpful to clarify the problem. Looks like the solution is very simple: you have a column with Line Item numb...

Still no attachments. Note that there are 2 buttons for finalizing an upload: -Add Files button, this will allow you to browse to select the fil...

Hi Libby, There is no attachment, and we cannot help without seeing the data structure. Can you try uploading again?

Hi Rathanak, You can use one of Microsoft code samples: Sub SaveAll() ' Store the Activeworkbook in a variable. Set aw = Act...

Hi Alexandra, VBA support for Excel 2016 Mac version is worse than the previous release, unfortunatelly. A workaround is to design the user form...

Hi Mike, Most probably, you have to clean up the office installation and perform a clean reinstall. See this article for instructions and tools ...

Hi Flipper, You're right, there should be more options for inputbox validations. You can put the inputbox in a loop, and exit the loop only when...

Thank you for sharing. You will find that the used range will include all formatted cells in the returned range, even if they are blanks. You ca...