XL2002: Worksheet Controls Missing from Command and Options Dialog Box in Interactive Web Page (292479)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q292479

SYMPTOMS

When you save a workbook in Microsoft Excel as a Web page with interactivity, the worksheet controls on the Workbook tab in the Command and Options dialog box may be missing. You can see this behavior if you view the page in a Web browser.

CAUSE

This behavior can occur when you protect your Excel workbook with a blank password, and then save it as a Web page.

RESOLUTION

To resolve this behavior, unprotect your workbook before you save it as a Web page.

MORE INFORMATION

If you save a password protected workbook as an interactive Web page, you receive the following error message:
The workbook you are trying to save is password protected. Password protected workbooks cannot be saved in a Web Page. To save this file as a Web Page, you must first remove the password.
If the password is blank, you do not receive this error message and you are allowed to save the workbook as an interactive Web page.

For more information about protecting workbooks, click Microsoft Excel Help on the Help menu, type password protect a worksheet or workbook in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:4/23/2003
Keywords:kberrmsg kbpending kbprb KB292479
©2002 Microsoft Corporation. All rights reserved.