Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-17-2015, 11:26 AM
Phil Payne Phil Payne is offline 2010 VBA prevent calculation when file is opened. Windows XP 2010 VBA prevent calculation when file is opened. Office XP
Novice
2010 VBA prevent calculation when file is opened.
 
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
 

Tags
manual calculation, show all, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
2010 VBA prevent calculation when file is opened. How to prevent the auto-calculation of the '% Complete' field in MS Project Professional 2013? VivekG1 Project 1 02-06-2015 05:33 AM
Project cannot save - file cannot be opened Guloluseus Project 22 01-28-2015 07:23 AM
Word Changes File Name When Opened canonm@pacbell.net Word 1 06-11-2014 10:04 PM
2007 file opened with 2010 messed up Intruder Project 1 11-21-2013 01:04 PM
Prevent Field Calculation with Dates from introducing line break? ztag Word 1 01-13-2012 04:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft