Help, excel will not drag formulas!!!

[BX]

Hi
I open an old spreadsheet and for some reason excel will not drag formulas. I drag a formula and the value for the first answer drag through all the cells. Also, when I deleted a row of cells, a value refering to the cells stayed the same like the cells hadn't been deleted. It seems like my excel is in a fixed mode. Any suggestions.

 

[sen_edp]

Hello

Go to tools-options-calculation-and check automatic

hth

 

[Andrew Poulsom]

Choose Tools, Options, Calculation and set it to Automatic.

Or press F9 to calculate in Manual mode (copies of formulas are not resolved until you do this). In Manual mode Calculate appears in the Status Bar if it needs to be done.

 

[justdream]

Hello

Go to tools-options-calculation-and check automatic

hth

you made my day