| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
| Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
| Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
Linear Mode
