Referring to Pivot Table in Excel 2003

M

Martin_xx

Using Excel 2003 I found a new "feature" for which I am need
workaround or fix.

If you refer in a formula to a data field in a pivot table, you
reference automatically converts to "Getpivot ..... ". This happe
when you type "=" and then point with the mouse to a data-field in th
pivot table.

If you then copy this formula into cells below (for example) the cel
references are no longer dynamically changed as in prior versions o
Excel. Your formula references become static and always refer to th
reference established in the first formula!

One fix is to type formulas with complete references instead o
pointing, which is rather annoying and error prone, especially when yo
have to reference to sheets in other workbooks.

Any ideas, how to mouse-point to a field and end up with references
that will change dynamically when copied?

Marti
 

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
GETPIVOTDATA from OLAP cube - grouped field 0
Referencing a pivot table 1
formulas referencing pivot table cells 1
Pivot Table from linked spreadsheets 1
Formulas with Pivot Table in Excel 2003 1
Linking to a Pivot Table 1
Error "invalid data source reference" for pivot table 5

Top