View Single Post
 
Old 02-17-2015, 11:26 AM
Phil Payne Phil Payne is offline Windows XP Office XP
Novice
 
Join Date: Apr 2013
Location: Glasgow, Scotland
Posts: 5
Phil Payne is on a distinguished road
Default 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
Reply With Quote