Microsoft KB Archive/288647

= XL2000: Pivot Table Error Message: Cannot Show or Hide Detail for This Selection =

Article ID: 288647

Article Last Modified on 4/7/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q288647



SYMPTOMS
When you double-click a total field in your PivotTable, you receive an error message that is similar to the following:

Cannot show or hide detail for this selection.



CAUSE
This error message occurs when the following conditions are true:
 * Your PivotTable contains more than one data field.

-and-
 * You double-click a total field for one of the data fields.

Excel cannot show details of a total if more than one total field exists in the PivotTable.



RESOLUTION
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Excel 2002.



WORKAROUND
To work around this problem, remove all data fields except one. To do this, follow these steps:
 * 1) In the PivotTable, click the arrow next to Data to display the list of data fields.
 * 2) Click to clear all but one of the check boxes for the data fields listed.
 * 3) Click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000

Keywords: kberrmsg kbbug kbqfe kbpending kbhotfixserver KB288647

-

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

© Microsoft Corporation. All rights reserved.