REF error while making changes in GETPIVOTDATA function
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
I am using Excel 2016. Ref the lecture 'Get Pivotdata is great! Extracting data from the Master Pivot Table'
In the lecture there is a suggestion to change the function with "Sum of"&B5, so that the formulae can be pasted in the other cells. But when I make this change, I am getting a REF error. Can you please suggest how i can get rid of the ref error.
2 answers ( 0 marked as helpful)
Hi!
Good to hear from you and thanks for reaching out.
I believe that the error is due to a missing blank space in the function. Should be
"Sum of"&B5 " rather than "Sum of"&B5". Please let me know if this helps.
Best,
Ned
Hello, I also had the same error; the issue was with spaces.
Here is my answer: "Sum of "& B5,
Notice the spaces after of and &.