Microsoft KB Archive/214026

= XL2000: Error Message: "Cannot Group that Selection" =

Article ID: 214026

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214026





SYMPTOMS
In Microsoft Excel 2000, when you attempt to group items in a PivotTable, you may receive the following error message:

Cannot group that selection.



CAUSE
A PivotTable range containing a blank row is interpreted as an incorrect data type, and therefore Excel does not allow you to group the data.



WORKAROUND
To work around this issue, follow these steps:  Remove all blank rows from the PivotTable data range. To refresh the PivotTable, follow these steps:  Select any item in the PivotTable. On the Data menu, click Refresh Data. </ol>

<div class="moreinformation_section">

MORE INFORMATION
To group data in a PivotTable, follow these steps:
 * 1) Select a range of data in the PivotTable.
 * 2) On the Data menu, point to Group and Outline, and then click Group.

The items are then grouped according to defining similarities, such as dates or times. However, when a blank row occurs in the PivotTable data range, the data cannot be grouped. A blank row is interpreted as a null value, which cannot be included as part of the grouped data.

Additional query words: database XL2000

Keywords: kberrmsg kbprb KB214026

-

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

© Microsoft Corporation. All rights reserved.