G
Guest
The cell references do not change when pasting formulas in excel 2003 - does
anyone know how to fix this?
anyone know how to fix this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Give an example for formula not changing its cell references! Are you sure
you use relative references (not absolute ones like $A$1)?
Regards,
Stefi
„Tammie†ezt Ãrta:
you use relative references (not absolute ones like $A$1)?
Regards,
Stefi
„Tammie†ezt Ãrta:
G
Guest
Since I don't know your level of familiarity with Excel, forgive me if I seem
simplistic. If your formulas have a $ before the column and/or row cell
reference, that could be the problem. For example, the formula =C4 + $A$1
wil give the sum of cells c4 and a1. But if you copy and paste the formula,
C4 will change according to position, but a1 will remain an absolute
reference. Remove the $ from the formula and all will become relative.
Short of an example of your formula and the result when copied and pasted,
that's all I can come up with.
simplistic. If your formulas have a $ before the column and/or row cell
reference, that could be the problem. For example, the formula =C4 + $A$1
wil give the sum of cells c4 and a1. But if you copy and paste the formula,
C4 will change according to position, but a1 will remain an absolute
reference. Remove the $ from the formula and all will become relative.
Short of an example of your formula and the result when copied and pasted,
that's all I can come up with.
G
Guest
I use pivot table reports, but in some cases I need to add different values
outside of the table. In excel 97, I would select the cells and it would be
fine. ie. a1+b1+c1 and so forth. When I would copy and paste, the cell
references would change accordingly. In excel 03 however, it keeps the same
cell references. Also, to note, it gives the pivot table referenced cell, so
it looks like this - =SUM(GETPIVOTDATA(" Beg. Units",$A$5,"Year",2006,"
Store","#26")+GETPIVOTDATA(" Beg. Units",$A$5,"Year",2007," Store","#26")).
I just upgraded to excel 03 and I am not enjoying my experience so far. Any
help is greatly appreciated.
outside of the table. In excel 97, I would select the cells and it would be
fine. ie. a1+b1+c1 and so forth. When I would copy and paste, the cell
references would change accordingly. In excel 03 however, it keeps the same
cell references. Also, to note, it gives the pivot table referenced cell, so
it looks like this - =SUM(GETPIVOTDATA(" Beg. Units",$A$5,"Year",2006,"
Store","#26")+GETPIVOTDATA(" Beg. Units",$A$5,"Year",2007," Store","#26")).
I just upgraded to excel 03 and I am not enjoying my experience so far. Any
help is greatly appreciated.
G
Guest
I use pivot table reports, but in some cases I need to add different values
outside of the table. In excel 97, I would select the cells and it would be
fine. ie. a1+b1+c1 and so forth. When I would copy and paste, the cell
references would change accordingly. In excel 03 however, it keeps the same
cell references. Also, to note, it gives the pivot table referenced cell, so
it looks like this - =SUM(GETPIVOTDATA(" Beg. Units",$A$5,"Year",2006,"
Store","#26")+GETPIVOTDATA(" Beg. Units",$A$5,"Year",2007," Store","#26")).
I just upgraded to excel 03 and I am not enjoying my experience so far. Any
help is greatly appreciated.
outside of the table. In excel 97, I would select the cells and it would be
fine. ie. a1+b1+c1 and so forth. When I would copy and paste, the cell
references would change accordingly. In excel 03 however, it keeps the same
cell references. Also, to note, it gives the pivot table referenced cell, so
it looks like this - =SUM(GETPIVOTDATA(" Beg. Units",$A$5,"Year",2006,"
Store","#26")+GETPIVOTDATA(" Beg. Units",$A$5,"Year",2007," Store","#26")).
I just upgraded to excel 03 and I am not enjoying my experience so far. Any
help is greatly appreciated.
G
Guest
Fine. But I still think the same logic applies. Take out the $ in your
formulas and see if that does the trick.
formulas and see if that does the trick.