Microsoft KB Archive/918772

= The sort order of an Excel 2007 PivotTable report is lost when you update the data in Excel Web Renderer =

Article ID: 918772

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-





SYMPTOMS
When you update the data in a Microsoft Office Excel 2007 PivotTable report in Excel Web Renderer, the sort order of the PivotTable report is lost.



CAUSE
This behavior may occur if you sort the PivotTable report by using a custom list in Excel 2007. The custom list is stored in the registry on the client computer on which the PivotTable report is sorted.



WORKAROUND
To work around this behavior, sort the PivotTable report by using one of the built-in sort options in Excel 2007. When you do this, the sort order will be retained when you update the PivotTable report in Excel Web Renderer. To use a built-in sort option, use one of the following methods, as appropriate for your situation.

Method 1: Specify the sort order
To work around this behavior, right-click a row in the PivotTable report, point to Sort, and then click the sort order that you want to use.

Method 2: Use the AutoSort functionality
You can configure Excel 2007 to sort the PivotTable report automatically every time that you update the PivotTable report. To do this, follow these steps:
 * 1) Right-click a row in the PivotTable report, point to Sort, and then click More Sort Options.
 * 2) Click More Options.
 * 3) Click to select the Sort automatically every time the report is updated check box.
 * 4) Click OK to close the More Sort Options (Field) dialog box.
 * 5) Click OK to close the Sort (Field) dialog box.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 ewr

Keywords: kbtshoot kbpivottable kbprb kbexpertisebeginner kbsorting KB918772

-

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

© Microsoft Corporation. All rights reserved.