How do I prevent Excel from automatically calculating when opening a large
workbook?

The workbook is used by a number of people, and I do not wish simply to ask
them to enable automatic calculation before opening the workbook.

Thanks,
Per

Give them a workbook that turns calculation to manual, then opens that other
workbook, then closes itself.

Option Explicit
Sub auto_open()
Application.Calculation = xlCalculationManual
Workbooks.Open Filename:="c:\my documents\excel\book2.xls"
ThisWorkbook.Close savechanges:=False
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Just like the xmas camera--open me first!

Pagman wrote:

How do I prevent Excel from automatically calculating when opening a large
workbook?

The workbook is used by a number of people, and I do not wish simply to ask
them to enable automatic calculation before opening the workbook.

Thanks,
Per

--

Dave Peterson

Thanks, but are there ways to do it directly in the workbook in order not to
have file name references (eg. in case files are moved or renamed)?

By the way, sorry about any confusion caused by writing enabling instead of
disabling...

Thanks,
Per

"Dave Peterson" skrev:

Give them a workbook that turns calculation to manual, then opens that other
workbook, then closes itself.

Option Explicit
Sub auto_open()
Application.Calculation = xlCalculationManual
Workbooks.Open Filename:="c:\my documents\excel\book2.xls"
ThisWorkbook.Close savechanges:=False
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Just like the xmas camera--open me first!

Pagman wrote:

How do I prevent Excel from automatically calculating when opening a large
workbook?

The workbook is used by a number of people, and I do not wish simply to ask
them to enable automatic calculation before opening the workbook.

Thanks,
Per

--

Dave Peterson