Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create pivot table formula without the GETPIVOTDATA function | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
using getpivotdata function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |