Excel formulas are not automatically updating
 

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

Excel formulas are not automatically updating
 

Hi Sam

ToolsOptionsCalculation make sure Auto Calculation is selected.

--
Regards

Roger Govier


"Sam M. via OfficeKB.com" <u4032@uwe wrote in message
news:5a1dae746c592@uwe...
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

Excel formulas are not automatically updating
 

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

Excel formulas are not automatically updating
 

Roger,

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

Seng


Roger Govier wrote:
Hi Sam

ToolsOptionsCalculation make sure Auto Calculation is selected.

Hello All,

[quoted text clipped - 9 lines]

Sam

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