Tag Archives: GETPIVOTDATA

SUMIF vs. GETPIVOTDATA in terms of performance in #Excel

Did you experience a slow workbook? How slow? Let’s say it takes more than 2 minutes to just open the file. This is actually what a colleague asked me for help. When I opened the workbook, I saw LOTS of … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

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