Microsoft KB Archive/930068

From BetaArchive Wiki
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


  • Microsoft Office Excel 2007


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


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


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:

Additional query words: XL2007

Keywords: kbtshoot kbpivottable kbprb kbexpertiseinter KB930068