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

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 :-)
------------------------------*------------------------------*----------------



"Dave" <(E-Mail Removed)> wrote in message
news:9055D41C-87C8-467E-A95E-(E-Mail Removed)...
> 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