ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automated Formulas in Excel 2003 (https://www.excelbanter.com/excel-discussion-misc-queries/62102-automated-formulas-excel-2003-a.html)

Amy Kelley

Automated Formulas in Excel 2003
 
When I first started using this document the formulas would update
automatically but they have stopped. I now have to click on every box, click
on the typing bar and press enter for each formula I want to update. Since
this document is quite extensive with linked pages I would like formulas to
update automatically. I am using Excel 2003.

pinmaster

Automated Formulas in Excel 2003
 

Looks like your calculations is set to MANUAL, goto
Tools/Option/Calculation and select AUTOMATIC.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=496458



All times are GMT +1. The time now is 07:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com