Microsoft KB Archive/930068

Knowledge Base

It may take longer than expected to create a large PivotTable in Excel 2007

Article ID: 930068

Article Last Modified on 10/15/2007

---

APPLIES TO

• Microsoft Office Excel 2007

---

SYMPTOMS

When you use Microsoft Office Excel 2007 to create a large PivotTable, the operation may take longer than expected.

CAUSE

This behavior may occur if many formatting options are enabled in Excel 2007. Excel 2007 must perform many update operations for each formatting feature that is enabled. These formatting features include the following:

• Worksheet styles such as level two subheadings
• Column auto fit
• Sorting
• Custom lists

WORKAROUND

To work around this behavior and to speed PivotTable creation in Excel 2007, turn off formatting features in Excel 2007. For more information about how to change formatting options in a PivotTable report, visit the following Microsoft Web sites:

http://office.microsoft.com/en-us/excel/HP101680321033.aspx

http://office.microsoft.com/en-us/excel/HA100870221033.aspx

Additional query words: XL2007

Keywords: kbtshoot kbpivottable kbprb kbexpertiseinter KB930068

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.