2010 VBA prevent calculation when file is opened.
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
|