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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Average of Subtotals in Pivot Table 0
2nd Pivot Table on Worksheet Crahes Excel 1
I can't add a calculated item to a pivot table 0
2003 formula for Pivot 1
Rows disappear in pivot table 1
How to add straight line from cell value in pivot table chart 1

Top