Microsoft KB Archive/931387

= Excel 2007 may appear to stop responding when you hide a selected item in a PivotTable =

Article ID: 931387

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
You expand a field in a PivotTable in Microsoft Office Excel 2007. This PivotTable is attached to an Online Analytical Processing (OLAP) cube. When you try to hide a selected item in the PivotTable, Excel 2007 may appear to stop responding.

Additionally, Excel 2007 may close unexpectedly, and you may receive the following error message:

Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.

When you view the data in the error report, the report contains an error signature that resembles the following error signature:



CAUSE
This problem may occur if you edit the hierarchy data of the OLAP cube outside Excel 2007.



WORKAROUND
To work around this problem, we strongly suggest that you do not edit the hierarchy data of the OLAP cube outside Excel 2007. Instead, make all changes to the hierarchy data in the OLAP cube by using Excel 2007.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: xl2007

Keywords: kbtshoot kbprb kbexpertisebeginner KB931387

-

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

© Microsoft Corporation. All rights reserved.