Microsoft KB Archive/99981

= Can't Use Print Report Feature with Protected Worksheet =

Article ID: 99981

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition

-



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.

