Speed Up MS Project 2007

When Microsoft Project 2007 slows to a crawl, speed it up with this simple tip.

As the project size grows, so does the file size. Updates to one entry can have a ripple effect. For example, changing a date early in the project's critical path can force changes to all the following dates. Project has to make all those calculation and then rewrite all those pieces of information in the project file.

You can speed up Project by turning off the automatic recalculations.

• In the menu bar, click on Tools. 
• In the pull-down menu, click on Options. 
• Click on the Calculation tab. 
• Change the calculation mode from Automatic to Manual. 
• Click on Close.

Setting MS Project Options for Manual Recalculation
(Click figure to view at full size.)

Entering data will go like it was a new project again.

Here's the drawback: To see the effect on calculated values, remember to click on Tools, Options, Calculation, and then click the Calculate Now button. 

There's a shorter way. You can set it up as follows.

• In your standard command toolbar, click on the down-arrow at the far right. See the illustration.

Accessing the Customize Toolbar Dialog Window
(Click figure to view at full size.)

• Click Add or Remove Buttons.
• Click on Customize.... 
• The Customize dialog menu should appear as shown in the next figure.
• Click the Commands tab of the dialog window.
• In the Categories list, click on Tools.
• Scroll down in the Commands list until you see Calculate Now.
• Using drag-and-drop, drag the Calculate Now icon to the standard command bar. You can place it anywhere you wish in the bar. I put mine next to the Help icon.

Adding a Calculate Now Button to the Standard Commands Toolbar
(Click figure to view at full size.)

You should have a Calculate Now button in your command bar, as shown in the next illustration.

The Calculate Now Button in the Standard Commands toolbar.

These changes personalize Project. They will apply every time you open Project, not just for the large file you are working on. To set recalculation back from Manual to Automatic, follow the same steps. You might, however, consider leaving the new button in your Standard Commands Toolbar.

Changing the frequency of recalculation from automatic to manual speeds up Microsoft Project 2007 for large project files. The same idea, and very similar steps, also works in Microsoft Excel. And now you know how to add frequently-used commands to (or take buttons you never use from) your toolbars, too!