Can't Use Print Report Feature with Protected Worksheet (99981)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
This article was previously published under Q99981 SYMPTOMS
In Microsoft Excel, when you use the Print Report command, 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 Print Report
command while the active sheet is protected. This behavior is by design
of Microsoft Excel.
Note that you can protect the worksheet objects and scenarios without
receiving the error message when you use the Print Report command.
WORKAROUND
To work around this behavior, use the appropriate method to unprotect the
document.
Microsoft Excel Versions 5.0 and Later
On the Tools menu, point to Protection, and then click Unprotect Sheet.
Microsoft Excel Version 4.0
On the Options menu, click Unprotect Document.
MORE INFORMATION
The Print Report command, which is available when you load the Report
Manager add-in file Report.xla, 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 worksheet where the cells are protected.
This problem no longer occurs in Microsoft Excel 2000. You still cannot
print a report from a protected worksheet, but you do receive the
following message: Cannot print or edit reports from a protected
document.
REFERENCES
"User's Guide 1," version 4.0, pages 542-544
| Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
|---|
| Keywords: | kberrmsg kbprb kbprint KB99981 |
|---|
|