Automatic changes in cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Office 2004 Test Drive User - 01 Feb 2008 11:42 GMT

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

Reply to this Message

Pete_UK - 01 Feb 2008 11:55 GMT

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

> 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

Reply to this Message

Pete_UK - 01 Feb 2008 12:56 GMT

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

Reply to this Message

Dave Peterson - 01 Feb 2008 12:49 GMT

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

Signature

Dave Peterson

Reply to this Message