Avoid geeting function GETPIVOTDATA
 

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

Avoid geeting function GETPIVOTDATA
 

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.


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=502380

Avoid geeting function GETPIVOTDATA
 

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


Gunnar Sandström wrote:
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




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html