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