Automatic changes in cells

  • Thread starter Thread starter Office 2004 Test Drive User
  • Start date Start date
O

Office 2004 Test Drive User

Hi for some reason I now have to save my work for any formlas etc to change
when I update a worsheet, how can I stop this as it is a pain and sometimes
I need to do changes to see how they work before saving the work.

Many thanks
 
Click on Tools | Options | Calculation tab and set to Automatic
calculation, as it is probably set to Manual. You can press F9 to
force a recalculation under a manual setting.

Make sure you save the file with the Automatic setting, to avoid it
happening next time.

Hope this helps.

Pete
 
The calculation mode is picked up from the first workbook you open in that
session of excel.

In xl2003, you can change the setting:
tools|options|calculation tab

But if you're unlucky enough to open a workbook that has manual calculation (as
the first workbook), you'll have to change this setting again (and again and
again).
 
Back
Top