Excel formulas are not automatically updating

[Sam M. via OfficeKB.com]

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

 

[Roger Govier]

Hi Sam

Tools>Options>Calculation> make sure Auto Calculation is selected.

 

[Guest]

Tools
Options
Calculation Tab
Select "Automatic"
OK

HTH,
Elkar

 

[Sam M. via OfficeKB.com]

Roger,

Thanks a bunch for your help. That did the trick.

Seng

Hi Sam

Tools>Options>Calculation> make sure Auto Calculation is selected.

Hello All,

[quoted text clipped - 9 lines]

Sam