How to get rid of the default command from Pivot table?

S

Shena

Dear all,

After creating a pviot table, I tried to add up 2 cells to add subtotal for
reference. But it is defaulted with "+GETPIVOTDATA".

How can I get rid of this command defaulted whereever I tried to take
figures from Pivot table for my own calculations.

Thanks.
 
F

Flemming

Hi Sheena,
If you type in the cell reference in stead of pointing and clicking with the
mouse on the cell, then you can avoid having the getpivotdata formula. Is
this what you meant ?

Best Regards

Flemming
 
Top