GETPIVOTDATA function

G

Guest

How do I turn on the GETPIVOTDATA function so that my reporting automatically
reflects the underlying pivot even if the pivot changes?
 
R

Roger Govier

Hi

If you are using the GETPIVOTDATA function, there is no need to turn
anything on for the formulae using the function to reflect changes in the
pivot table itself.

Refreshing the PT, will refresh the calculations to reflect changes in the
underlying data, and these changes will automatically then reflect in the
cells using your Getpivotdata as part of their formulae.

If your question is about turning on the Getpivotdata icon, then take a look
at Debra Dalgleish's site
http://www.contextures.com/xlPivot06.html

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
ISERROR on GETPIVOTDATA 1
2007 Excel - GETPIVOTDATA 2
#ref 1
Find a cell address from a GETPIVOTDATA() Fomula 2
GETPIVOTDATA function 2
GetPivotData Question 1
GETPIVOTDATA function on pivot filter 0

Top