Excel picks up the calculation mode for the application from the first workbook
opened.

Your workbook_open code that changes calculation to manual isn't helping your
workbook--That event doesn't fire until the workbook is open--and excel has
already recalced (if it's in automatic mode) by that time.

You could provide them with two workbooks--the first changes calculation to
manual, then opens the second, then turns calculation to automatic, then closes
itself.

But I would think that as soon as the calculation is changed back to automatic,
the whole process would slow down just as much as when you opened the workbook
(with calculation set to automatic).



wrote:

I've got a large workbook which continually calculates cells while web
queries and other macros are executed upon document load. I can
disable Automatic Calculation in Workbook_Open and the worksheet opens
very quickly. After loading the workbook, I can turn automatic
calculation back on, but I have users of this workbook that are
probably not capable of doing this on their own. What I would like to
do is find a trigger to turn automatic calculation back ON, but I'm
not sure what that is. I tried using Worksheet_Change, but unless I
type into the cell, it doesn't show it as changing. This is probably
easy, but I haven't found anything in the help files or in this forum.

Any help or ideas would be greatly appreciated.
Dale.

--

Dave Peterson