autofill

[grambo]

I have a very simple problem using autofill in Excel 2003; when I drag
down it copies the number in the cell instead of the formulas. The
strange thing is the right formulas are in the copied cells, but they
still have the original number from the first cell. What is the
problem!?

Thanks anyone,

Grambo

 

[Dave Peterson]

My guess is that you have calculation set to manual.

Try tools|options|Calculation tab and select automatic.