Groups Option Works Improperly in CROSSTAB.XLA with Excel

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.
For Min enter 0; for Max enter 60. Choose OK twice.

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.

REFERENCES

Microsoft Excel 3.0 OnLine Help, "Macro Library - Data Crosstabs."

KBCategory: kbother
KBSubcategory:
Additional reference words: noupd

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: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.