Improving Performance in Excel 2007

http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Summary: Learn about the increased worksheet capacity in Microsoft Office Excel 2007 and techniques that you can use as you design and create worksheets to improve calculation performance. (40 printed pages)

Charles Williams, Decision Models Limited

October 2006

Applies to: Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002, Microsoft Excel 2000

Contents

• Overview

• The "Big Grid" and Increased Limits in Excel 2007

• Why Is Calculation Speed Important?

• Understanding Calculation Methods in Excel

• Calculating Workbooks, Worksheets, and Ranges

• Controlling Calculation Options

• Making Workbooks Calculate Faster

• Finding and Prioritizing Calculation Bottlenecks

• Excel 2007 Performance Improvements

• Tips for Optimizing Bottlenecks

• Workbook Opening, Closing, Saving, and Size

• Conclusion

• Additional Resources