Tools
Options
Calculation Tab
Select "Automatic"
OK

HTH,
Elkar

"Sam M. via OfficeKB.com" wrote:

Hello All,

Happy New Year! I have an excel issue where the formulas are not updating
unless I click on the cell and then place the cursor on the cell address
field (at the top of the excel sheet). Once I do that and click away, the
cell displays the updated total. Is there an option/setting that is causing
this? The spreadsheet was working fine before. Thanks.

Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1