Get Pivot data

  • Thread starter Thread starter akk
  • Start date Start date
A

akk

Hi

I use XP and when i write a formula giving refernce to a
cell within a pivot, xl automatically references it
with "getpivotdata". It is useful at times, but not
always. Is there an option to unselect this?

Thanks
 
You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.
 
Back
Top