NOT GETTING THE GETPIVOTDATA OPTION
in Data Analysis with Excel Pivot Tables / GetPivotData is great! Extracting data from the Master Pivot Table
When practicing, I am not getting the getpivotdata option, Please see below what i am getting when I enter the equals sign and link the cell to a cell from the pivot table. Instead of getting the GETPIVOTDATA function, it shows "PIVOT TABLE!"
0 answers ( 0 marked as helpful)
Submit an answer
Don't understand why am i getting error in some cells while others are responding fine.