Microsoft KB Archive/930068

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.