Microsoft KB Archive/69821

{| = CROSSTABS.XLA Incorrectly Referred to in Lotus 1-2-3 Help =
 * width="100%"|

Last reviewed: April 29, 1998

Article ID: Q69821 3.00 WINDOWS kbother

SUMMARY
The procedure for data distribution on the Lotus Help menu states:

See the Microsoft Excel User's Guide for information on the CROSSTABS.XLA add-in macro There is no file called CROSSTABS.XLA. The word CROSSTABS is actually too long to be a DOS file. The actual file is called CROSSTAB.XLA (notice that the &quot;S&quot; is missing.)

MORE INFORMATION
With the Lotus Help feature turned on under the Workspace command in the Options menu, the &quot;/&quot; key brings up Lotus Help. From there, you can choose &quot;D&quot; for data, then &quot;D&quot; for distribution. At this point, you get the message listed above.

The Crosstabs macro does have the capacity to do the same commands as data distribution. However, you must know how to load it.

You should load CROSSTAB.XLA, which is located in the \EXCEL\QE subdirectory. Also, this file is not installed unless Q+E is installed during Setup.

Once you have loaded this file, you can choose Crosstabs from the Data menu to perform data distribution routines. To have Crosstabs load automatically, simply place the CROSSTAB.XLA file in the XLSTART directory.

For more information about Data Crosstabs, look under the Help Index, in the Macro Library section for the Data Crosstabs topic. Currently, there is no other documentation regarding the use of the Crosstabs macro.