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