XL97: Some Commands Are Not Listed in the Customize Dialog Box (177873)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q177873

SYMPTOMS

When you use the Customize dialog box in Microsoft Excel 97 to change the Worksheet menu bar, the following commands may be missing from the Commands list. 
   Command              Menu name     Submenu name
   -----------------------------------------------
   Save as HTML         File
   Custom Views         View
   Report Manager       View
   Goal Seek            Tools
   Solver               Tools
   Conditional Sum      Tools         Wizard
   File Conversion      Tools         Wizard
   Lookup               Tools         Wizard
   Web Form             Tools         Wizard
   Template Wizard      Data
NOTE: There is a Custom Views command in the Commands list. However this command has a drop-down list box. The original Custom Views command does not have a drop-down list box.

CAUSE

This problem occurs when you click Customize on the Tools menu, and then click the Commands tab to add a command that is listed in the table in the "Symptoms" section.

WORKAROUND

You can restore some of the commands by removing, and then adding the reference to an add-in. To do this, follow these steps:
  1. On the Tools menu, click Add-ins.
  2. Click to clear the <Add-In name> check box. Click OK. 
       Add-In name                           Command
   ----------------------------------------------------

   Conditional Sum Wizard               Conditional Sum
   File Conversion Wizard               File Conversion
   Internet Assistant Wizard            Save as HTML
   Lookup Wizard                        Lookup
   Report Manager                       Report Manager
   Solver Add-In                        Solver
   Template Wizard with Data Tracking   Template Wizard
   Web Form Wizard                      Web Form
  3. On the Tools menu, click Add-ins.
  4. Click the <Add-In name> check box. Click OK.

Restoring the Custom Views and Goal Seek Commands

Clicking an add-in does not restore the Custom Views and Goal Seek commands. To restore these commands, follow these steps.

NOTE: By following these steps, you reset the entire Worksheet toolbar.
  1. On the Tools menu, click Customize, and then click the Toolbars tab.
  2. Click Worksheet Menu Bar.

    If you clear the Worksheet Menu Bar check box, click the check box again to select it.
  3. Click Reset.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

To view the Customize dialog box, use either of the following methods:

  • On the Tools menu, click Customize. -or-

  • Point to Toolbars on the View menu, and then click Customize. -or-

  • Move the mouse pointer over the toolbar or menu bar, and then right- click it. Click Customize on the shortcut menu.

REFERENCES

For more information about adding menu commands, click the Index tab in Microsoft Excel Help, type the following text

menus, adding

and then double-click the selected text to go to the "Add a command to a menu" topic.
Modification Type:MajorLast Reviewed:10/21/2000
Keywords:kbbug kbui KB177873
©2002 Microsoft Corporation. All rights reserved.