Article ID: 172279
Article Last Modified on 10/22/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q172279
SYMPTOMS
When you attempt to sort a field in a PivotTable, the following error message appears:
If you click Details, an error message similar to the following appears:
If you click Close, the program closes.
CAUSE
This problem occurs when you do the following:
- You create a PivotTable with more than one row field. -and-
- You merge row labels in the PivotTable. -and-
- You sort a column in the PivotTable.
WORKAROUND
Before you sort data in a PivotTable, clear the Merge Labels check box in the PivotTable Options dialog box.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
REFERENCES
For more information about sorting data in a PivotTable, click the Index tab in Help, type the following text
pivottables, sorting
and then double-click the selected text to go to the "Sorting data in a PivotTable" topic.
Additional query words: XL97 pivot table
Keywords: kberrmsg kbbug KB172279