Formulas stop calculating

B

brodiemac

I have an existing spreadsheet with different formulas in it. Just recently
I noticed that the forumlas stopped calculating. It's odd since I can cut a
formula out of a cell and paste it back into the same cell and it will work
again. What is causing this? It's annoying to have to spend 30 mins
updating formulas this way when I have only 2 mintues worth of data to imput.
 
C

ChrisA

Brodie:

Go to Tools, Options, Calculate Tab, and check to see if your spreadsheet is
set to calculate automatically. If it is not then you will need to set it so
that it is by clicking the appropriate radio button. Or you can keep your
spreadsheet as it is and just press F9 when you want your cells to calculate.
Sometimes this is a good idea if you have a ton of formulas in your
spreadsheet.

Cheers.
 
B

brodiemac

That was exactly it, thank you!

ChrisA said:
Brodie:

Go to Tools, Options, Calculate Tab, and check to see if your spreadsheet is
set to calculate automatically. If it is not then you will need to set it so
that it is by clicking the appropriate radio button. Or you can keep your
spreadsheet as it is and just press F9 when you want your cells to calculate.
Sometimes this is a good idea if you have a ton of formulas in your
spreadsheet.

Cheers.
Click to expand...
 
Top