Get Pivot data

[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

 

[Debra Dalgleish]

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.