2010 VBA prevent calculation when file is opened.

[Phil Payne]

Hello all,

Does anyone know how I can prevent auto calculation of a file when it is being expanded, just after file is open, to show all tasks?

I have a large programme plan with sub programmes and sub projects. In 2003 this plan took just 40 seconds to show all - in 2010 up to 5 1/2 minutes.



I am looking at other possible reasons for this but for the short term I would like to know if there is vba code to turn off auto calculation when 'show all' is used that I can implement now. (Users are fed up waiting for the plan to fully open.)

Thanks,

Phil