| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I automatically update stock prices? | Excel Discussion (Misc queries) | |||
| How do I set my webpage to automatically update a changing spread. | Excel Discussion (Misc queries) | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| Update multiple workbooks automatically | Excel Worksheet Functions | |||
| Update fields with blanks | Excel Discussion (Misc queries) | |||
Linear Mode
