XL: PivotTable Cannot Group Data

 Last reviewed: February 2, 1998
Article ID: Q115471
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

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, Microsoft Excel does not allow you to group the data.

WORKAROUND

To group the data in the PivotTable, follow these steps:

  1. Remove all blank rows from the PivotTable data range.

  2. Do the following to refresh the PivotTable: 

        a. Select any item in the PivotTable.


        b. On the Data menu, click Refresh Data.

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 similar items, 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: 98 97 7.00 5.00 database XL98 XL97 XL7 XL5
Keywords : xlpivot kbtool
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,98
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.