Microsoft KB Archive/72752

{| = Groups Option Works Improperly in CROSSTAB.XLA with Excel =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q72752 The information in this article applies to:
 * Microsoft Excel for Windows, version 3.0

SUMMARY
If the Groups option under Row Options or Column Options is chosen while using the Microsoft Excel CROSSTAB macro, CROSSTAB will produce a report with blank group headings and zeroes for all of the data.

MORE INFORMATION
CROSSTAB.XLA is a Microsoft Excel Add-In macro, located in the QE subdirectory, that builds a crosstab or cross-tabulation table based on the records in an internal or external database. A crosstab summarizes records from a database in a two-dimensional table.

Steps to Reproduce Problem
 Open the CROSSTAB.XLA macro from the QE subdirectory.  Enter the following data into a worksheet: A1:    Object          B1:     Inches A2:    Rock            B2:     15 A3:    Rock            B3:     19 A4:    Rock            B4:     1 A5:    Rock            B5:     4 A6:    Rock            B6:     47 A7:    Rock            B7:     11 A8:    Rock            B8:     38 A9:    Rock            B9:     60 A10:   Rock            B10:    44

This database represents the number of objects thrown at John Smith's office window from the bushes, and the distance by which they missed.  Select the range A1:B10 and choose Set Database from the Data menu. From the Data menu, choose Crosstabs. In the Column Field, select Object. In the Row Field, select Inches. Choose Row Options. Select Groups. In the edit box next to the Groups button, type 12.</li> For Min enter 0; for Max enter 60. Choose OK twice.</li></ol>

The report generated will have the right format (1 column by 12 rows); however, all of the numbers in the data table will be zeroes. The report should contain the number of times the objects missed by 0-4.99 inches, 5.0-9.99 inches, etc. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.