Microsoft KB Archive/292479

= XL2002: Worksheet Controls Missing from Command and Options Dialog Box in Interactive Web Page =

Article ID: 292479

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



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.

Additional query words: XL2002 XL2000 prb OfficeErrorMessages 10034

Keywords: kberrmsg kbpending kbprb KB292479

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.