Formulas stop calculating
 

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.

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.

"brodiemac" wrote:

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.

That was exactly it, thank you!

"ChrisA" wrote:

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.

"brodiemac" wrote:

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.

Formulas stop calculating
 

Chris you knew exactly where to go to correct it... thank you very much... :-)

"ChrisA" wrote:

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.

"brodiemac" wrote:

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.