XL98: Can't Use Print Report Feature with Protected Worksheet

• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel, when you click the Report Manager command on the View menu, you receive the following error message:

Cannot print or edit reports from a protected document.

CAUSE

This error message occurs when you are trying to use the Report Manager command while the active sheet is protected.

This behavior is by design of Microsoft Excel.

WORKAROUND

To work around this behavior, use the following method to unprotect the document:

On the Tools menu, point to Protection, and then click Unprotect Sheet.

Note that you can protect the worksheet objects and scenarios without receiving the error message when you use the Report Manager command.

MORE INFORMATION

The Report Manager command, which is available when you load the Report Manager add-in file Report Manager, gives you the ability to print several views and scenarios of a worksheet in succession. Because changing scenarios means changing the contents of cells, this operation cannot be done on a worksheet where the cells are protected.

REFERENCES

For more information about Report Manager, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

Report Manager

protecting workbooks and sheets

Additional query words: XL98

Keywords : kberrmsg kbprint kbdta xladdins
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb