XL98: Can't Use Print Report Feature with Protected Worksheet (190631)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q190631 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
and then click Show Topics. Select the "Combine views and scenarios into a
printed report" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
For more information about protection, 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
protecting workbooks and sheets
and then click Show Topics. Select the "Control access to workbooks and
worksheets" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kberrmsg kbprb kbprint KB190631 |
|---|
|