How about creating a 2nd workbook to open the real workbook.

It can change the calculation mode to manual, then open the real workbook, then
close itself.



Mitch Powell wrote:

It is critical that a particular workbook NOT calculate upon opening, so I
used the following:

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub

The problem is that if calculation is is already in auto mode when workbook
is opened, calculation takes place before this code can run and turn it off.
Any ideas?

--

Dave Peterson