These are suggestions:
1. make sure no worksheet or workbook templates (.XLT) are forcing back to
manual

2. make sure no start-up macros are forcing back to manual calculation
--
Gary's Student


"mm1861" wrote:

Hi,
I'm running Office 2003 SP1 on XP SP2. I have an Excel SS that will not
retain the caluclation setting so that I have to change it to Automatic each
time I open the SS.

This is not a large file and has only a few functions.

Anyone have a suggestion as to how I can get Automatic to stay turned on?

thanks, in advance.
mm