ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automating Formulas in Excel 2003? (https://www.excelbanter.com/excel-discussion-misc-queries/62140-automating-formulas-excel-2003-a.html)

Amy Kelley

Automating Formulas in Excel 2003?
 
When I first started using the document the formulas would update
automatically but that has stopped. Now I have to click on the cell, click
on the typing bar and press Enter for each cell I want updated. Since this
document is quite extensive with linked pages I would greatly appreciate the
formulas to update automatically. I am using excel 2003.

Bob Phillips

Automating Formulas in Excel 2003?
 
Go to ToolsOptionsCalculation and make sure the Automatic button is
checked, not the Manual.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Amy Kelley" wrote in message
...
When I first started using the document the formulas would update
automatically but that has stopped. Now I have to click on the cell,

click
on the typing bar and press Enter for each cell I want updated. Since

this
document is quite extensive with linked pages I would greatly appreciate

the
formulas to update automatically. I am using excel 2003.





All times are GMT +1. The time now is 05:41 PM.

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