![]() |
Automatically recalculating in Excel
Our spreadsheets use to automatically recalculate when we entered additional
information. Now, we have to manually ask for the spreadsheet to recalculate. It is not isolated to one spreadsheet, workbook, or file. Is this a setting in Excel that can be changed? |
Allison, tools, options, calculation, check automatic
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Allison" wrote in message ... Our spreadsheets use to automatically recalculate when we entered additional information. Now, we have to manually ask for the spreadsheet to recalculate. It is not isolated to one spreadsheet, workbook, or file. Is this a setting in Excel that can be changed? |
Check your settings, ToolsOptionsCalculate and make sure it is set to
automatic not manual. -- HTH RP (remove nothere from the email address if mailing direct) "Allison" wrote in message ... Our spreadsheets use to automatically recalculate when we entered additional information. Now, we have to manually ask for the spreadsheet to recalculate. It is not isolated to one spreadsheet, workbook, or file. Is this a setting in Excel that can be changed? |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com