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.



    Pivot Table Data Crunching
    Pivot Table Data Crunching for Microsoft Office Excel 2007
    ISBN: 0789736012
    EAN: 2147483647
    Year: 2003
    Pages: 140

    Similar book on Amazon

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net