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
 
Ad

Advertisements

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

Top