Resolved: error while trying to extract from the master pivot table
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
Hi, i am getting an error whenever i try to use the Ampersand function in order to concatenate the "sum of" with another string.i have tried it both on my self made sheet and the course download sheet, but i get the same error: " moving or deletind cells caused an invalid cell reference, or function is returning reference error"
Not sure why.. i have attached a screen shot
3 answers ( 0 marked as helpful)
Ned Krastev
Instructor
Hi,
Good to hear from you!
The reason is that you are missing a blank space.
Just add a blank space next to "Sum of" like this "Sum of " and the function should work.
Best,
Ned
WORKS NOW .. :) thanks..
Ned Krastev
Instructor
Glad I was able to help!