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

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

Guest

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.
 
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
 
Back
Top