ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why don't fields update automatically when new numbers are input?. (https://www.excelbanter.com/excel-discussion-misc-queries/14995-why-dont-fields-update-automatically-when-new-numbers-input.html)

Frustrated in NJ

Why don't fields update automatically when new numbers are input?.
 
I am new to Excel 2003 and there seems to be some setting that needs to be
turned on as I've set up a basic formulas and if the data changes nothing
updates.

Chip Pearson

Is calculation set to automatic? Go to the Tools menu, choose
Options, then the Calculation tab. There, ensure that
calculation is set to automatic.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Frustrated in NJ" <Frustrated in
wrote in message
...
I am new to Excel 2003 and there seems to be some setting that
needs to be
turned on as I've set up a basic formulas and if the data
changes nothing
updates.




Greg

It sounds like auto calculate is not enabled.

Tools - Options - Calculation
Make sure Automatic is selected

"Frustrated in NJ" wrote:

I am new to Excel 2003 and there seems to be some setting that needs to be
turned on as I've set up a basic formulas and if the data changes nothing
updates.



All times are GMT +1. The time now is 06:54 PM.

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