View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default 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