Error - Formulas not Calculated Automatically

[Crilley]

I searched the site and could not find any information on this subject - if it exists, just let me know. Also, if this thread is in the wrong place, I apologize in advance.

I am not extremely adept at Excel, but I use it for several things at work. I have Excel 2003 and SP3. I have a spreadsheet that had been working just fine until this morning. (I have not updated anything recently.) Now, however, when I enter data into a cell, any other cell that would use that data to calculate something, will not do so. For example, if I enter something in A1, then B1, which was [=(A1*3)] or whatever, does not calculate, unless I physically click on the formula for B1 in the function bar. The same then goes for any other cell that uses a formula with B1. Given the amount of data I have to enter and calculate, this would be a huge hassle to do manually. Is there any known way of fixing this?

I hope I made myself understood - and thanks for the help.

 

[Trevor G]

Welcome to the forum,

It sounds as though the workbook needs to auto calculate, look at the Tools Menu and Options then in the formula side you shoud have an option to Auto Calculate.

The following comes from the Help File

<TABLE class=collapse><TBODY><TR class=trbgodd><TD class=noborder vAlign=top align=left>F9</TD><TD class=noborder vAlign=top align=left>Calculates all worksheets in all open workbooks. SHIFT+F9 calculates the active worksheet.
CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
CTRL+F9 minimizes a workbook window to an icon.
</TD></TR></TBODY></TABLE>

 

[Crilley]

Wow, that unbelievably simple thing fixed it.

I would feel stupid, except that I can't imagine how that box got UNclicked in the first place . . .

Thanks for your help!

 

[Trevor G]

Glad to help.