Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA
Does anyone have an opinion about the utility of this function? I've just
been handed a spreadsheet with a bunch of pivot tables, and a bunch of calculations which use the GETPIVOTDATA function. My take is it's easier just to enter the cell reference of the pivot table value you want to use in a calculation. Am I missing something here? What are the advantages, if any, of the GETPIVOTDATA function? Dave -- Brevity is the soul of wit. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA
Dave,
If you change the PT, GETPIVOTDATA will still retrieve the correct data - your cell reference won't. HTH, Bernie MS Excel MVP "Dave F" wrote in message ... Does anyone have an opinion about the utility of this function? I've just been handed a spreadsheet with a bunch of pivot tables, and a bunch of calculations which use the GETPIVOTDATA function. My take is it's easier just to enter the cell reference of the pivot table value you want to use in a calculation. Am I missing something here? What are the advantages, if any, of the GETPIVOTDATA function? Dave -- Brevity is the soul of wit. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA
Thanks--that's what I thought...
So it's fair to say that GETPIVOTDATA is dynamic, in the sense that using it with a pivot table whose data is refreshed will insure that calculations using the pviot table data are updated. Whereas a direct cell reference will not. This answers a bunch of questions -- Brevity is the soul of wit. "Bernie Deitrick" wrote: Dave, If you change the PT, GETPIVOTDATA will still retrieve the correct data - your cell reference won't. HTH, Bernie MS Excel MVP "Dave F" wrote in message ... Does anyone have an opinion about the utility of this function? I've just been handed a spreadsheet with a bunch of pivot tables, and a bunch of calculations which use the GETPIVOTDATA function. My take is it's easier just to enter the cell reference of the pivot table value you want to use in a calculation. Am I missing something here? What are the advantages, if any, of the GETPIVOTDATA function? Dave -- Brevity is the soul of wit. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
GETPIVOTDATA
Hi Dave
You can think of GetPivotData as being analogous to Index, Match but you are giving it Fields to match against as opposed to ranges. -- Regards Roger Govier "Dave F" wrote in message ... Thanks--that's what I thought... So it's fair to say that GETPIVOTDATA is dynamic, in the sense that using it with a pivot table whose data is refreshed will insure that calculations using the pviot table data are updated. Whereas a direct cell reference will not. This answers a bunch of questions -- Brevity is the soul of wit. "Bernie Deitrick" wrote: Dave, If you change the PT, GETPIVOTDATA will still retrieve the correct data - your cell reference won't. HTH, Bernie MS Excel MVP "Dave F" wrote in message ... Does anyone have an opinion about the utility of this function? I've just been handed a spreadsheet with a bunch of pivot tables, and a bunch of calculations which use the GETPIVOTDATA function. My take is it's easier just to enter the cell reference of the pivot table value you want to use in a calculation. Am I missing something here? What are the advantages, if any, of the GETPIVOTDATA function? Dave -- Brevity is the soul of wit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA Excel 2003 Problem | Excel Discussion (Misc queries) | |||
GETPIVOTDATA with an Array | Excel Worksheet Functions | |||
GETPIVOTDATA Bug | Excel Worksheet Functions | |||
"Best Practices" Use of GetPivotData Function | Excel Worksheet Functions | |||
Copy GetPivotData Outside Report | Excel Worksheet Functions |