When I type a formula referencing a pivot table, I cannot copy the formula down

Problem

If you are working with Excel 2002 or a later version, you will find that Excel has an annoying default setting that revolves around the GetPivotData function.

Excel automatically inserts the GetPivotData function into any cell where you are trying to enter a formula referencing your pivot data. The issue is that the GetPivotData function automatically references the cells in your pivot table as absolute references, making it impossible to simply copy your formulas down and get the right answer.

Solution

To resolve this issue, take the following steps:

1.	Go to the application menu bar and select Tools, Customize.
2.	In the Commands tab, select Data.
3.	Find Generate GetPivotData and drag it to any one of your toolbars.
4.	Click Close.
5.	Click the Generate GetPivotData button to turn off this feature.
6.	Re-enter your formula with this feature turned off.