Automatic changes in cells

  • Thread starter Office 2004 Test Drive User
  • 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
 
P

Pete_UK

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
 
D

Dave Peterson

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).
 
Top