Stop searching. Start learning and developing your excel skills.
Macro
VBA
Formula
Function
Shortcut
Tricks

» » HowTo Disable GetPivotData

HowTo Disable GetPivotData

July 25, 2017 |
GETPIVOTDATA is complicated. Very hard to understand the logic. I really hate GETPIVOTDATA. Good thing is that this can be disable.


How To:
  1. Click at Pivot Table area
  2. GoTo Analyze Ribbon
  3. Under PivotTable field
  4. Click Options
  5. Untick Generate GetPivotData



No comments:

Post a Comment