cancelling getpivot formula when setting formula outside pivot ta.

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

Guest

In the office 2003 version an automatic getpivotdata formula is created when
setting a formula outside the pivot table.this makes it impossible to copy
the formula to other cells as all data becomes fixed.
how can I turn to my old formula setting mode?
 
In stead of selecting the cell by clicking the button of your mouse to use in
your formule, you have to type the cell number in your formula (example type
=a2-b2 in stead of clicking on cell a2 & than on b2 with your mouse).

Normally this should do it.
 
You must log in or register to reply here.

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 reference issue 0
Getpivot function - 2
Change GETPIVOTDATA cell reference to A1 style 1
formulas referencing pivot table cells 1
GETPIVOTDATA General 3
linking cell to Pivot Table data 3
Referring to Pivot Table in Excel 2003 1
getpivotdata custom subtotal cell reference 3

Back
Top