Excel sets calculation to Manual automatically
 

Excel 2002, 2003, WinXP
An OP I am helping has Excel 2003. I have 2002.
I wrote a good bit of code for him in a file called Bens.xls that resides in
his XLSTART folder.
I have almost the same file in my XLSTART folder.
That file has nothing but code and is about 400 KB big.
I'll call my file MyBens.xls and his HisBens.xls.
WithOUT HisBens.xls in his XLSTART folder, Excel opens with calculation set
to automatic. No problem.
With HisBens.xls installed in his XLSTART folder, Excel opens with
calculation set to Manual.
I have no such problem with MyBens.xls file installed in my XLSTART folder.
So he sends me HisBens.xls file.
I install HisBens.xls file in place of MyBens.xls file in my XLSTART folder.
I have the same problem he has.
HisBens.xls file has no Auto_Open file. No Workbook_Open file. No
protected (hidden) modules.
Does anyone have any clues or ideas as to why this is happening? Thanks for
your help. Otto

Excel sets calculation to Manual automatically
 

I think I recall that calculation mode is set by the first opened workbook.
Have your user open only HisBen.xls, set the calculation mode to automatic
then save and close HisBen.xls and exit Excel.

Next time he starts Excel calc should be automatic.

Tim

--
Tim Williams
Palo Alto, CA


"Otto Moehrbach" wrote in message
...
Excel 2002, 2003, WinXP
An OP I am helping has Excel 2003. I have 2002.
I wrote a good bit of code for him in a file called Bens.xls that resides
in
his XLSTART folder.
I have almost the same file in my XLSTART folder.
That file has nothing but code and is about 400 KB big.
I'll call my file MyBens.xls and his HisBens.xls.
WithOUT HisBens.xls in his XLSTART folder, Excel opens with calculation
set
to automatic. No problem.
With HisBens.xls installed in his XLSTART folder, Excel opens with
calculation set to Manual.
I have no such problem with MyBens.xls file installed in my XLSTART
folder.
So he sends me HisBens.xls file.
I install HisBens.xls file in place of MyBens.xls file in my XLSTART
folder.
I have the same problem he has.
HisBens.xls file has no Auto_Open file. No Workbook_Open file. No
protected (hidden) modules.
Does anyone have any clues or ideas as to why this is happening? Thanks
for
your help. Otto

Excel sets calculation to Manual automatically
 

Excel is openning Bens.xls. Excel sets auto/manual to the choise of the
first openned workbook.

Open Bens.xls explicitly, set calculation to auto, and then save the file
back in XLSTART
--
Gary's Student


"Otto Moehrbach" wrote:

Excel 2002, 2003, WinXP
An OP I am helping has Excel 2003. I have 2002.
I wrote a good bit of code for him in a file called Bens.xls that resides in
his XLSTART folder.
I have almost the same file in my XLSTART folder.
That file has nothing but code and is about 400 KB big.
I'll call my file MyBens.xls and his HisBens.xls.
WithOUT HisBens.xls in his XLSTART folder, Excel opens with calculation set
to automatic. No problem.
With HisBens.xls installed in his XLSTART folder, Excel opens with
calculation set to Manual.
I have no such problem with MyBens.xls file installed in my XLSTART folder.
So he sends me HisBens.xls file.
I install HisBens.xls file in place of MyBens.xls file in my XLSTART folder.
I have the same problem he has.
HisBens.xls file has no Auto_Open file. No Workbook_Open file. No
protected (hidden) modules.
Does anyone have any clues or ideas as to why this is happening? Thanks for
your help. Otto