| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas not updating until file is saved
I'm using Excel 2003 11.5612.5606. I recreated one of our workbooks that has various formulas in it. Some of which are just something like =A1 where A1 contains the customer name. The customer name doesn't show up in that cell until after the file is saved. What did I do wrong? -- Tech ------------------------------------------------------------------------ Tech's Profile: http://www.excelforum.com/member.php...o&userid=15107 View this thread: http://www.excelforum.com/showthread...hreadid=492762 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas not updating until file is saved
The file is probably set for manual recalculation - you can press F9 to
recalculate at any time. To set it for automatic recalculation, select Tools | Options | Calculation Tab. Pete |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas not updating until file is saved
That was it. Thanks! -- Tech ------------------------------------------------------------------------ Tech's Profile: http://www.excelforum.com/member.php...o&userid=15107 View this thread: http://www.excelforum.com/showthread...hreadid=492762 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locating saved Excel file | Excel Discussion (Misc queries) | |||
| copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
| Some formulas need file refresh in same worksheet | Excel Worksheet Functions | |||
| How do I insert the date the file was saved in the MS Excel foote. | Excel Discussion (Misc queries) | |||
| Help... File Not Saved | Excel Discussion (Misc queries) | |||
Linear Mode
