Forcing Automatic Calculation

[Mike]

Hi All,
I can't seem to get my excel files to keep the
automatic calculation turned on- on more than one
workboot. Every day I have to re-enable it. How can I get
the Auto calculation to turn on in each workbook every
time they load? I'm guessing it would go in each
workbook's open event, but I'm not sure of the syntax.

Thanks,
Mike

Excel 2000
Windows 2000

 

[Guest]

Try

Application.Calculation = xlCalculationAutomati

 

[Chip Pearson]

Mike,

The calculation mode is set by the first workbook that is opened.
Look in your XLStart folder for a workbook named Book.xlt, open
that template, and ensure that calculation mode there is set to
automatic. Also check the calculation mode of your personal.xls
file, if you are using one.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Mike]

Thanks Chip (and John).

I posed this same question several months ago and learned
about the first open workbook setup at that time. I have
tried on several occasions to verify that the first open
workbook is set to auto. I ALWAYS open the same file first
everyday. I do however work on a shared computer, but I
have my own logon. The file that I open first is used by
other users. Could they be opening another file first,
resetting the main workbook to manual? I really would like
to get the root cause of this because it is driving me
crazy not nowing how to fix it correctly. I will probably
use John's solution for now.

Thanks for the fast response,

-Mike