Spreadsheets not calculating new information

[EJK]

At work, our company relies on excel spreadsheets to generate reports to
track our daily progress. Under normal circumstances, they work well without
incident.

We currently use Microsoft Office 2000 in our office, which includes Excel
2000 and we are using Windows XP Professional as our operating systems,
although I am not sure which version it is.

Recently I experienced a period of about an entire week where the
spreadsheets were not calculating any of the new information that was being
manually entered. The previous calculations were in tact, but nothing would
change with the addition of new figures, unless I would double click on each
individual cell and hit enter after. This is a very tedious task and am not
sure that all of the calculations are actually correct, since we have cells
that generate a daily average once a number is placed in a certain cell.

As mysteriously as the problems began, they also mysteriously stopped about
a week later.

Yesterday the problem returned, and it also seems to be affecting all of the
spreadsheets that I have worked on and is also a problem for my boss, so I
don't think its isolated to just my PC. We are networked, so apparently it is
not just a problem for myself.

Has anyone in the discussion group experienced anything like this before,
and if so, how can we correct it?

Thank you. I appreciate any help that we can get.

 

[Roger Govier]

Hi

It sounds as though Calculation has been set to Manual.
Go to Tools>Options>Calculation>tick Automatic.

This setting is determined by the setting of the first workbook opened
in an Excel session.
On some occasions, you are loading a workbook which has it's setting as
Manual, and that is determining the behaviour for the other files you
open.

Either, always open first, a file where you know the setting is
automatic, or change the setting of the "errant" file which is causing
your problem, from Manual to Automatic then Save the file.

 

[EJK]

You are so correct!! Thank you so much!

Hi

It sounds as though Calculation has been set to Manual.
Go to Tools>Options>Calculation>tick Automatic.

This setting is determined by the setting of the first workbook opened
in an Excel session.
On some occasions, you are loading a workbook which has it's setting as
Manual, and that is determining the behaviour for the other files you
open.

Either, always open first, a file where you know the setting is
automatic, or change the setting of the "errant" file which is causing
your problem, from Manual to Automatic then Save the file.

 

[Stan Brown]

Tue, 8 May 2007 04:53:30 -0700 from EJK

Recently I experienced a period of about an entire week where the
spreadsheets were not calculating any of the new information that was being
manually entered.

Tools | Options | Calculation
and select "Automatic"