Microsoft KB Archive/172279: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 101: | Line 101: | ||
</div> | </div> | ||
and then double-click the selected text to go to the | and then double-click the selected text to go to the "Sorting data in a PivotTable" topic. | ||
</div> | </div> |
Latest revision as of 11:05, 21 July 2020
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