Excel formulas don't update until save

  • Thread starter Thread starter monica
  • Start date Start date
M

monica

Any ideas on this one? We are using Office 2003 -
formulas will not update/calc until a save is done, then
they work at that moment. Is this a setting that can be
changed?

Thanks in advance
 
monica said:
Any ideas on this one? We are using Office 2003 -
formulas will not update/calc until a save is done, then
they work at that moment. Is this a setting that can be
changed?
Click to expand...

Hi Monica,

It sounds like you have calculation set to manual. Choose
Tools/Options/Calculation from the Excel menu and make sure the option
button labeled "Automatic" is selected in the Calculation section at the top
of the dialog. Then save the workbook.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Back
Top