Microsoft KB Archive/101166

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 09:17, 20 July 2020 by X010 (talk | contribs) (Text replacement - """ to """)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Excel: Crosstab Returns "Invalid Value in GROUP Field"

Last reviewed: September 12, 1996
Article ID: Q101166

The information in this article applies to:

  • Microsoft Excel for Windows, versions 4.0, 4.0a


If you are using the Crosstab ReportWizard, and you are grouping items by a numeric constraint, you may receive the following error message when you attempt to enter the constraint:

   Invalid value in GROUP field


This problem will occur if the number format applied to the data in the spreadsheet is not at same the level of precision, or at a higher level of precision, as the numeric constraint.

This situation occurs regardless of whether you are using a built-in or a custom number format.


Format the values to have the same number or a greater number of decimal places as the value you specify for the constraint value.


Microsoft has confirmed this to be a problem in Microsoft Excel version 4.0 for Windows. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


In the Crosstab ReportWizard you select row and column categories. In these categories you can select how to group the results of the crosstab report by entering the group constraint in the In Groups Of field. In Microsoft Excel for Windows, if you enter a value that contains decimal places that are not displayed in the worksheet database, you will receive an error message.

This problem does not occur in Microsoft Excel for the Macintosh.

KBCategory: kberrmsg


Additional reference words: 4.00 4.00a

Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.