Formula Replication
Is your calculation set to manual? Tools/Options/Calculation - change to
automatic.
Or, you could be using absolute references ($A$1 or A$1) instead of relative
references (A1).
"fredmr" wrote:
I am trying to replicate a formula down a Column and all I get is an
exact(absolute) copy.
I have tried to use the "Drag Handle" and the
"Highlight-Edit-Copy-Drag/Highlight-Paste" functions but All I get is a
"Copy" with no updating of the "Row" information.
Any suggestions along this line would be helpful.
Thanks in advance,
Fred
PS: I am using Xcel 2003
|