GETPIVOTDATA

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

Guest

How do I deactivate the automatic "GETPIVOTDATA" function when referencing a cell in a pivot table?
 
There is a button on the Pivot Table Toolbar that will toggle this feature
on/off. It look slike a small square spreadsheet with an arrow coming up
diagonally from the bottom right hand corner. Hover over it and it will say
'Generate GetPivotData'

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Danito said:
How do I deactivate the automatic "GETPIVOTDATA" function when referencing a
Click to expand...
cell in a pivot table?
 
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
2007 Excel - GETPIVOTDATA 2
Pivot Table with Data Model Connection - getpivotdata #REF error 0
ISERROR on GETPIVOTDATA 1
Find a cell address from a GETPIVOTDATA() Fomula 2
Pivot Table GETPIVOTDATA 2
getpivotdata doesn't like certain numbers?? 2
#ref 1

Back
Top