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