Prevent Auto Calculation On Opening a Workbook

[Excel-Access]

Hi

I have a workbook that is shared with about 20 individuals.

Once it is open I set the calculations to manual.

What I am finding is that, if I open it from scratch, it is calculating and causing issues as to the length of time it takes.

Is there way in Excel 2007 to disable this on opening a workbook or does someone have a VBA and can share this with instructions.

Once an individual makes changes, they would hit F9 and then save the workbook at the moment.

Thanks

[MarvinP]

Hi,

Try putting this code behind the Worksheet module. Test to see if it does what you want.

Please Login or Register  to view this content.