copy a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

when I try to copy a formula in excel 2003 the original
value appears as the result.
e.g if cell c1 is equal to a1*b1 ,when I drag cell c1
down the sheet the result in cell c2 & c3 etc are the
same as cell c1, even if the figures in a2 & a3 are
different.
This happens for all formulas.
 
Check that calculation is set to automatic

Tools>Options...Calculation

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top