Microsoft KB Archive/99350

= Microsoft Knowledge Base =

Excel: Limits on Number of Categories in Crosstab Wizard
Last reviewed: September 12, 1996

Article ID: Q99350

The information in this article applies to:


 * Microsoft Excel for Windows, version 4.0, 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
The Crosstab ReportWizard in Microsoft Excel has a limit of 16 row categories, 16 column categories, and 16 value fields. These limits are by design.

MORE INFORMATION
The Crosstab ReportWizard uses the CROSSTAB.CREATE function to generate crosstab tables. Because CROSSTAB.CREATE has a limit of 16 row categories, 16 column categories, and 16 value fields, the Crosstab ReportWizard is similarly limited. For example, once you select 16 row categories, the Add button is no longer available (it is dimmed) in Crosstab ReportWizard.