Article ID: 928982
Article Last Modified on 10/15/2007
APPLIES TO
- Microsoft Office Excel 2007
SYMPTOMS
When you try to ungroup a group in a PivotTable in Microsoft Office Excel 2007, Excel closes unexpectedly. Additionally, you receive the following message:
When you click OK to continue with the undo, you receive the following error message:
When you click OK to close the error message dialog box, you receive the following error message:
When you view the data in the error report, you see an error signature that resembles the following error signature:
| Application name | Application version | Module name | Module version | Offset |
| Excel.exe | 12.0.4518.1014 | Excel.exe | 12.0.4518.1014 | 00b71f94 |
CAUSE
This issue may occur when the group in the PivotTable has the following Top/Bottom Rules conditional formatting applied:
- Top 10 Items
- Bottom 10 Items
WORKAROUND
To work around this issue, use one of the following methods:
- Do not group items that have the Top 10 Items or Bottom 10 Items conditional formatting applied.
- When you must group items, apply a different conditional formatting to items in the PivotTable.
MORE INFORMATION
For more information about conditional formatting, click Microsoft Office Excel Help or press F1, type conditional formatting in the Search box, and then click Search.
Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 kbNoOfficeAlertID
Keywords: kberrmsg kbtshoot kbpivottable kbformat kbprb kbexpertisebeginner KB928982
