Microsoft KB Archive/77502

{| = Excel Err Msg: CROSSTAB.XLA Error Messages =
 * width="100%"|

Last reviewed: April 29, 1998

Article ID: Q77502 3.00   | 3.00 WINDOWS | OS/2 kbother The information in this article applies to:


 * Microsoft Excel for Windows, version 3.0
 * Microsoft Excel for OS/2, version 3.0

SUMMARY
Various error messages may be returned when running the CROSSTAB.XLA add-in macro with Microsoft Excel version 3.0.

For more information about the add-in macros, please refer to Appendix B in the &quot;Microsoft Excel User's Guide,&quot; and search for Macro Library in the on-screen Help for Microsoft Excel.

MORE INFORMATION
The error messages include the following:


 * Crosstab macro must be named name.
 * Database is not valid.
 * You must define a valid database before using the Crosstab command.
 * Database cannot contain blank fieldnames.
 * At least two columns are required to do a crosstab.
 * Upper limit must be larger than lower limit.
 * No data found in the specified row range.
 * No data found in the specified column range.
 * Only one row of data. Grouping cannot be done.
 * Only one column of data. Grouping cannot be done.
 * QE.XLA must be located in the QEMACRO subdirectory of your XLSTART directory.
 * Can't open database table: table_name.
 * Unable to build table from Q+E.
 * No data records retrieved.
 * The crosstab can't be created.