Stopping Autoupdate

[direktoren]

I have just been handed an old template which my boss have made - Its quite large, but runs uncomplainly.

My problem is; It uses autoupdate and i need to archive the data at the end of each quarter. Thus, when I'm opening an old workbook from the archive, it updates the figures! I know I can get around this by simply turning off macros, but, since I would then have to turn them off and on constantly, I was thinking there must be an easier way!

So is it possible to save a copy of a workbook, with the macros turned off?

Thanx in advance
/Nick

[VBKNIGHT]

just press-hold the shift key while opening the file.

[RobDog888]

You can pass the parameter to not update links or not if your opening these workbooks programmatically.
Application.Workbooks.Open Filename:="C:\Test.xls", UpdateLinks:=False