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

On Feb 1, 11:42*am, Office 2004 Test Drive User
<heepenm...@yahoo.co.uk> wrote:
> 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

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



Office 2004 Test Drive User wrote:
>
> 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

--

Dave Peterson

You're welcome.

Pete

On Feb 1, 12:28pm, Office 2004 Test Drive User
>
> <heepenm...@yahoo.co.uk> wrote:
>
> Wonderful, I will try that
>
> thanks