Excel has a little trap. It takes the Option from the first file it opens.
Say you don't have Excel open and double-click a file that was saved in the
Manual mode. Excel will open the file and be in the Manual mode. If Excel
remains open and then you:

File Open

a dozen other files, it will remain Manual


I suggest you go back to recently saved files:

1. open them
2. switch to Automatic
3. save them
--
Gary''s Student - gsnu200765


"T" wrote:

It's selected when Excel is opened with out any files. What would cause it
change all of a sudden in files that weren't like that before?

Thank you very much for your help!!!!!!

"Gary''s Student" wrote:

Tools Options Calculation Automatic
--
Gary''s Student - gsnu200765