Avoid geeting function GETPIVOTDATA

[Gunnar Sandström]

Hi!
Can i avoid geeting function GETPIVOTDATA when in do a cell formula on a
pivo table cell in excel 2003 ?

I know that if i refer in the cell to ex: =C3 it works like in older versons
o f excel but is it a simpler way?

Regards gunnar

 

[chalky]

Unfortunately this seems to be an issue in Excel 2003 and i am afraid i
am aware of no other method to avoid getting this error other than
typing in the cell reference manually.

 

[Debra Dalgleish]

There are instructions here for adding the Generate GetPivotData button
to a toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html