Tag Archives: GETPIVOTDATA

Get rid of the GETPIVOTDATA without disabling it

If you do Pivot Table, I believe you should have experienced the following too.   GETPIVOTDATA is good.  But sometimes we just want a simple cell reference.  We may disable the GETPIVOTDATA easily by going to Pivot Table Option –> Uncheck … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 2 Comments