ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Automatically recalculating in Excel (https://www.excelbanter.com/excel-worksheet-functions/38766-automatically-recalculating-excel.html)

Allison

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?

Paul B

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?




Bob Phillips

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