Prevent Calculation On Open

[u742884]

Is there a way to prevent a file from calculating when you open it?

 

[Greg Truby]

*not tested*

I would try putting

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

in the workbook's code module.

 

[Oaktree]

Greg:

If the current calculation setting is automatic, changing the calculation setting in a workbook_open event results in the workbook recalculating and THEN changing the setting to manual.

I wrote some more notes about calculation at http://www.mrexcel.com/board2/viewtopic.php?t=184349

 

[u742884]

I already have:

Sub auto_open()
With Application
.Calculation = xlManual
.CalculateBeforeSave = True
End With
[Some other stuff]

End Sub()

The [other stuff] is occurring and the calculation mode is changed to manual, but it still calc's the file upon opening.

 

[u742884]

Oaktree,

I saw your post after submitting mine. I read through the notes you referred to. I do not want to change any of their default settings so the which of these is correct:

I can write code to close all open files, and regardless of which calc mode they were in, my file will open, read my code to make calc manual and not calc until I make it do so. This would be perfect world.

I can direct the users to close all open files, regardless of which calc mode they were in, my file will open, read my code to make calc manual and not calc until I make it do so.

I have to direct the users to change calc mode before opening this file.

 

[Oaktree]

The second one is right. If no workbooks are open (*including the default Book1) and your file was saved with calculation set to manual, your file will open with calculation set to manual. You shouldn't even need that line of code in your macro at all.

(The first one is incorrect because the workbook would calculate first, then fire the workbook_open macro you'd set up to close the other workbooks)