Formulas stop working on all excell spreads at the same time
 

The concern is did swomething get turned off in excel or is this the work of
a virus?

Formulas stop working on all excell spreads at the same time
 

i suggest you look at your TOOLS / OPTIONS and chose the CALCULATIONS tab,
you may find that you have the 'manual' option checked.

Change to AUTOMATIC - then close excel and reopen all your documents. You
may need to do this for each doc, but sometimes Excel has a 'funny five mins'

Formulas stop working on all excell spreads at the same time
 

Hi

The Automatic/Manual setting of calculation is Excel-wide. This means that
it's either on for all, or off for all. Whether it is on or off is
determined by its setting in the first workbook you open in the session.

Andy.

"BuffySlay" wrote in message
...
i suggest you look at your TOOLS / OPTIONS and chose the CALCULATIONS tab,
you may find that you have the 'manual' option checked.

Change to AUTOMATIC - then close excel and reopen all your documents.
You
may need to do this for each doc, but sometimes Excel has a 'funny five
mins'

Formulas stop working on all excell spreads at the same time
 

And... it will take on the setting of the most recent file you open... much
to my annoyance when all of a sudden auto-calc gets turned off...


<Andy wrote in message ...
Hi

The Automatic/Manual setting of calculation is Excel-wide. This means that
it's either on for all, or off for all. Whether it is on or off is
determined by its setting in the first workbook you open in the session.

Andy.

"BuffySlay" wrote in message
...
i suggest you look at your TOOLS / OPTIONS and chose the CALCULATIONS
tab,
you may find that you have the 'manual' option checked.

Change to AUTOMATIC - then close excel and reopen all your documents.
You
may need to do this for each doc, but sometimes Excel has a 'funny five
mins'