Excel worksheets will not recalculate a
I have Excel 2003 running on XP. Some worksheets will not automatically
recalculate, but will only update when I press Save. I undertake a function weekly, and use a blank worksheet which is renamed each week. However, it is only some weeks where the auto recalc does not work. I have checked knowledge base etc with no help available. This problem also occurs on some other worksheets - all created in Office 2003. |
Excel worksheets will not recalculate a
Hi Robert,
Try: Tools | Options | Calculation | verify that the automatic option is selected. --- Regards, Norman "Robert" wrote in message ... I have Excel 2003 running on XP. Some worksheets will not automatically recalculate, but will only update when I press Save. I undertake a function weekly, and use a blank worksheet which is renamed each week. However, it is only some weeks where the auto recalc does not work. I have checked knowledge base etc with no help available. This problem also occurs on some other worksheets - all created in Office 2003. |
Excel worksheets will not recalculate a
Thanks Norman, but the box was already checked.
Robert "Norman Jones" wrote: Hi Robert, Try: Tools | Options | Calculation | verify that the automatic option is selected. --- Regards, Norman "Robert" wrote in message ... I have Excel 2003 running on XP. Some worksheets will not automatically recalculate, but will only update when I press Save. I undertake a function weekly, and use a blank worksheet which is renamed each week. However, it is only some weeks where the auto recalc does not work. I have checked knowledge base etc with no help available. This problem also occurs on some other worksheets - all created in Office 2003. |
All times are GMT +1. The time now is 09:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com