how to refer the cell insteat of Getpivotdata in excel 2003?
 

Just got excell 2003 upgrade, I am use to create a formula with some
reference to a pivot table cell and copy it down, the 03 version referer to
the pivot table cell as +GETPIVOTDATA("A","B") instead of +C4, how to I set
up excel so it refers to the cell as C4 instear of +GETPIVOTDATA("A","B")

Thanks

how to refer the cell insteat of Getpivotdata in excel 2003?
 

View/Toolbars/Customize
In the Commands tab, click Data
In the Commands (right list), scroll down near the bottom & find "General
GetPivotData". Click on that & drag it to any toolbar. Close the Customize
dialog, and then you can toggle this setting on/off. When it's off, you get
the simple reference; when it's on, you get the GETPIVOTDATA formula.



"David" wrote:

Just got excell 2003 upgrade, I am use to create a formula with some
reference to a pivot table cell and copy it down, the 03 version referer to
the pivot table cell as +GETPIVOTDATA("A","B") instead of +C4, how to I set
up excel so it refers to the cell as C4 instear of +GETPIVOTDATA("A","B")

Thanks