Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In Excel 2003, when you reference a cell in a pivot table now instead of
getting a simple cell reference you now get a GETPIVOTDATA function return which is a pain when trying to copy a formula outside of the pivot table. Is there anyway to get around this? |
#2
![]() |
|||
|
|||
![]()
Hi
see: http://www.contextures.com/xlPivot06.html -- Regards Frank Kabel Frankfurt, Germany "NewExcel2003User" schrieb im Newsbeitrag ... In Excel 2003, when you reference a cell in a pivot table now instead of getting a simple cell reference you now get a GETPIVOTDATA function return which is a pain when trying to copy a formula outside of the pivot table. Is there anyway to get around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell Referencing | Excel Discussion (Misc queries) | |||
Generate GetPivotData | Setting up and Configuration of Excel | |||
vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
GetPivotData | Excel Worksheet Functions | |||
Graphs and sheet referencing? | Excel Worksheet Functions |