Microsoft KB Archive/99879

{|
 * width="100%"|

XL4: Computer Hangs with CROSSTAB.CREATE Function

 * }

-

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 &quot;Function Reference,&quot; 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 &quot;Function Reference&quot;). 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 &quot;Out of Memory.&quot; 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.