Microsoft KB Archive/928982

= Error message when you try to ungroup a group in a PivotTable in Excel 2007: &quot;Excel cannot complete this task with available resources&quot; =

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:

Excel cannot complete this task with available resources. Choose less data or close other applications.

Continue with Undo?

When you click OK to continue with the undo, you receive the following error message:

Excel cannot complete this task with available resources. Choose less data or close other applications.

When you click OK to close the error message dialog box, you 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, you see an error signature that resembles the following error signature:



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

-

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

© Microsoft Corporation. All rights reserved.