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 - 27 Jul 2006 19:43 GMT
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.

Signature
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
> Hi,
>
[quoted text clipped - 10 lines]
> Thanks,
> Dave