GETPIVOTDATA function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I turn on the GETPIVOTDATA function so that my reporting automatically
reflects the underlying pivot even if the pivot changes?
 
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
 
You must log in or register to reply here.

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
Pivot Table with Data Model Connection - getpivotdata #REF error 0
#ref 1
getpivotdata doesn't like certain numbers?? 2
GETPIVOTDATA function 2
GetPivotData Question 1

Back
Top