G
Guest
How do I deactivate the automatic "GETPIVOTDATA" function when referencing a cell in a pivot table?
K
Ken Wright
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
----------------------------------------------------------------------------
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
----------------------------------------------------------------------------
cell in a pivot table?Danito said: