Ryan,

We had checked that already, good idea though.

"ryguy7272" wrote:

The cells are probably formatted as Text. Right-click those pesky cells,
click Format Cells, and click General and the click 'OK'. You may have to
click the cell again, and hit enter to commit the change.

Try it and see if it helps.

Good luck,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ntssupport" wrote:

* Problem occurs in Office 2000/3

We have some excel files that will not automatically calculate formulas.
The option for automatic or manual calculations is set to automatic.

We have read other posts about Excel having a "trap" where it takes the
calculation option (auto/manual) from the first file that is open. Then
applies that to subsequent files that are opened after it. We have not been
able to verify this in our tests.

We have went through all of our excel files on our systems and none of our
files have the manual setting.

The only way to get calculations to work is to close the file and reopen the
file. Upon reopening of the file, the formulas update/calculate.

The problem is on many machines. Reinstallation of Office itself has not
resolved the problem. Applying the latest patches has not resolved the
problem.

Looking for some help. It would greatly be appreciated. This drives our
users crazy.

Thank you!