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

ID: Q99981

The information in this article applies to:

Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows

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

Additional query words: 4.00a 8.00 97 XL97 XL7 XL5 XL4 addins

Keywords : kberrmsg kbprint kbdta xladdins xlprint
Version : WINDOWS:4.0,4.0a,5.0,7.0,97; MACINTOSH:4.0,5.0
Platform : MACINTOSH WINDOWS
Issue type : kbprb