Microsoft KB Archive/98717

= Microsoft Knowledge Base =

Excel: Crosstab ReportWizard Returns Error if Sheet Protected
Last reviewed: September 12, 1996

Article ID: Q98717

The information in this article applies to:


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

SUMMARY
The Crosstab ReportWizard included with Microsoft Excel version 4.0, will not create a table when the worksheet containing the database is protected. If you attempt to create the crosstab table on a new worksheet, you will receive the following error message

Out of memory! and you will be unable to create the crosstab table. If you attempt to create the crosstab table on the same worksheet, no error message will appear but you will be unable to create the table.

To create a crosstab table using the Crosstab ReportWizard, you must unprotect the worksheet that contains the database.

MORE INFORMATION
The above information applies only to the creation of crosstab tables. After you create a crosstab table, you can reprotect the worksheet that contains the database. If the crosstab table is on another worksheet, you can modify or recalculate the crosstab table even if the worksheet is protected. However, if the crosstab table is on the same worksheet as the database, the worksheet must remain unprotected if you want to modify or recalculate the table.