Automatic Calculation Issue

[Guest]

Hi,

I have a spreadsheet that I have created that includes many formulas,
conditional formatting, and links. I brought up the spreadsheet today and
nothing was calculating automatically. I went to the Tools drop down and
under Options I noticed that the Calculation method changed from Automatic to
Manual.

I didnt change this, does anyone know why this would have changed on it's
own??

Thanks,
Dave

 

[Ken Wright]

Probably no-one. Excel takes it's calculation state from the first workbook
you open after
launching an Excel session. It may be that your personal.xls, or a
timesheet
file you use every day that launches automatically has been saved whilst in
manual mode. Find and fix.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------