Possible Calcuation problem

  • Thread starter Thread starter Outthink
  • Start date Start date
O

Outthink

There is an Excel workbook stored on a shared drive on the server that
behaves properly when all but one individual accesses it. When this person is
using the workbook, none of the formulas will recalculate when changes are
entered.

We have checked Tools, Options (on the problem pc), and Excel is set to
automatically recalculate.

This problem is not occuring on any other computer in the area. When others
use the workbook it behaves properly.

Any help you can give me is greatly appreciated.

Roberta
 
Excel will take the calculation mode from the first file it opens. If a
person opens the file first and the file had the mode set to manual, then the
mode will be manual.

However if the person had already opened another file and the mode was set
to automatic, and then the person opened the file in question, the mode will
remain automatic.
 
That is also not the case here. The mode is Automatic for all files used.
We have opened other files first, then opened the problem file. When we check
the mode for the files it is still Automatic.

We have also tried the "CTRL ALT F9" solution offered in another post I read.

We are going to try rebuilding the user's profile.
 
Back
Top