Function GETPIVOTDATA

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

Guest

How can I unable that excel is inserting the GETPIVOTDATA function automatically when I just want to link the value out of a Pivot Table in my formula?
 
You can change this setting, or you can type an equal sign, and type the
cell reference, instead of clicking on the cell to reference it.

To change the setting --
Choose Tools>Customize
Select the Data category on the Commands tab
Near the end of the commands list, select Generate GetPivotData
Drag the command to one of your toolbars
Click Close

Use this button to toggle the feature on and off.
 
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 :-)
----------------------------------------------------------------------------



Jeroen Kok said:
How can I unable that excel is inserting the GETPIVOTDATA function
Click to expand...
automatically when I just want to link the value out of a Pivot Table in my
formula?
 
Back
Top