Excel Help

I have an Excel spreadsheet that I use to caluclate s/r levels for different markets after I enter the H/L/C. Today, after entering these #'s the spreadsheet didn't do the calculations. When I clicked in the cell, the formula is still there, but no calculation is being done; Only when I click on the formula bar and hit enter does the calculation get done. Very curious problem. I should mention that I have been using this SS for months, with a different tab for each day, and have never seen a problem like this. Any help would be greatly appreciated

 

Have you checked that Tools - Options - Calculation - Automatic is selected?

 

That is exactly it; Thanks so much- Just a question; How is it possible that that was changed?

 

Assuming that you didn't change the calculation mode, the most likely reasons are:

- another workbook, set to manual calc (from a download, maybe?) was opened earlier than this one, either today or recently; or

- a new workbook or worksheet was created, from template or by a copy command, and your template / copy source is set to manual calc.

The issue is that Excel requires all open workbooks, and all worksheets in a workbook, to use the same calc mode. The mode is saved with the file.