Cells not updating

[mv8167]

Im sure i turned some switch off, I just dont know where/what to do to get my cells to update again.

My cells are not updating on any of my spreadsheerts. To update my cells, I must go to each cell, highlight the function and hit Enter to get thde cell to recalulate the function.

I right-clicked the bottom toolbar at Calculate, but i dont find a solution to get my cells to auto-recalulate.

Any thoughts?

Thx!

 

[shyy]

In your excel options, you can set to either manual/automatic under the Formula tab

Try hitting F9 also to calculate

 

[MARK858]

How to change the mode of calculation in Excel 2007/Excel 2010

Click the Microsoft Office Button (File in 2010), and then click Excel Options.
On the Formulas tab, select the calculation mode that you want to use (i.e. automatic).

How to change the mode of calculation in Excel 2003 and in earlier versions of Excel

Click Options on the Tools menu, and then click the Calculation tab.
Under Calculation, click the calculation mode that you want to use (i.e. automatic).

 

[mv8167]

Thx Guys,

I am using Excel v2010, so under the Formulas tab, I found the Calculation Options and set this to Automatic. Perfect!

I dont know how I ended up switching this to Manual but thx for the ideas on how to fix my issue.

Lorena

 

[MARK858]

If you use any macros I would check them to make sure that none of them set the calculation mode to manual or false without putting it back to automatic or true later in the code

 

[shyy]

mv8167

This happens to my sometimes when I open a clients excel. Don't know why that would effect my own settings, but that could be the reason why

 

[mv8167]

Thx for the additional ideas. Much appreciated.

Lorena