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.

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.

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.

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.