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

G

Guest

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GETPIVOTDATA #REF! error XL2003/2010 1
2003 formula for Pivot 1
Use cell_ref in place of an item in get pivot data function 2
getpivotdata 1
GETPIVOTDATA 2
GETPIVOTDATA in Excel 2007 2
GetPivotData Multiple Fields 6
Pivot Table with Data Model Connection - getpivotdata #REF error 0

Top