REF error while making changes in GETPIVOTDATA function

Question

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.

Answer 1

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

REF error while making changes in GETPIVOTDATA function

Submit an answer

related questions