Formula's stop working

  • Thread starter Thread starter Ken Smith
  • Start date Start date
K

Ken Smith

Has anyone encountered Formula's that stop working in
Excel 2000? Recently I've had several users state that
all of a sudden, their formula's stop working. I
uninstalled and reinstalled Office 2000 Pro on one users
PC then about a week later, it happened again. Any
thoughts on this?

Thanks in advance.
Ken
 
Hi Ken,

Tools>Options>Calculation, check Automatic

This setting is taken from the first workbook opened, and then applies to
all open workbooks.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Ken

The most likely cause is that Tools>Options>Calculation "automatic" got
switched to "manual"

Excel takes the calculation mode of the first workbook opened in a session.

If that workbook was saved as "manual" calc, then subsequent workbooks opened
will be "manual" no matter which mode they were saved under.

Gord Dibben Excel MVP
 
thank you, I'll get with the user and try that.
thanks again, hope this is it.

Ken
-----Original Message-----
Ken

The most likely cause is that
Click to expand...
Tools>Options>Calculation "automatic" got
switched to "manual"

Excel takes the calculation mode of the first workbook opened in a session.

If that workbook was saved as "manual" calc, then subsequent workbooks opened
will be "manual" no matter which mode they were saved under.

Gord Dibben Excel MVP
Click to expand...
 
Back
Top