XL4: Computer Hangs with CROSSTAB.CREATE() Function

ID: Q99879

The information in this article applies to:

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

SYMPTOMS

On page 83 of the "Function Reference," version 4.0, the Grouping_Index section for the CROSSTAB.CREATE() function contains incorrect information.

STATUS

This is a known problem in the versions of Microsoft Excel listed above. The problem does not occur in Microsoft Excel versions 5.0 and later.

MORE INFORMATION

If you use the wrong Grouping_index number with the CROSSTAB.CREATE() function, you will receive unexpected results. For example, if you use the number 1, the values will be grouped by seconds, not by days (as is indicated in the "Function Reference"). Because days and time are measured in different units, Microsoft Excel will be unable to build the table and your computer may appear to lock up (hang) and may eventually return the error message "Out of Memory." If this occurs, you will need to restart Microsoft Excel.

The table incorrectly contains the following:


   Grouping_index         Description
   ------------------------------------------------
   0                      No grouping or text field
   1                      Group by days
   2                      Group by weeks
   3                      Group by months
   4                      Group by 30-day periods
   5                      Group by quarters
   6                      Group by years

The table should contain the following information:


   Grouping_index    Description
   ------------------------------------------------
   0                      No grouping or text field
   1                      Group by seconds
   2                      Group by minutes
   3                      Group by hours
   4                      Group by days
   5                      Group by weeks
   6                      Group by months
   7                      Group by 30-day periods
   8                      Group by quarters
   9                      Group by years

NOTE: The CROSSTAB.CREATE function is not available in Microsoft Excel version 5.0 because you can use the PivotTable feature to summarize the data in a table. However, in Microsoft Excel version 5.0, if you load the Crosstab ReportWizard add-in from a previous version of Microsoft Excel, and use the CROSSTAB.CREATE macro function, the above behavior occurs.

REFERENCES

"Function Reference," version 4.0, pages 82-84

Additional query words: 4.00a XL4 addins crosstabulation freeze bomb crash data crosstab.xll


Keywords          : 
Version           : WINDOWS:4.0,4.0a; MACINTOSH:4.0
Platform          : MACINTOSH WINDOWS 
Issue type        :

Last Reviewed: July 23, 1999