XL2000: Some Commands Are Not Listed in the Customize Dialog Box

View products that this article applies to.

This article was previously published under Q200708

Symptoms

When you use the Customize dialog box in Microsoft Excel to change the Worksheet menu bar, the following commands may be missing from the Commands list.

   Command                Menu name     Submenu name
   -------------------------------------------------

   Links                  Edit
   Object                 Edit
   Custom Views           View
   Report Manager         View
   AutoSave               Tools
   Goal Seek              Tools
   Solver                 Tools
   Add-ins                Tools
   Data Analysis          Tools
   Conditional Sum        Tools          Wizard
   Lookup                 Tools          Wizard
   Template Wizard        Data
   MS Access Form         Data
   MS Access Report       Data
   Convert to MS Access   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.

↑ Back to the top

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.

↑ Back to the top

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 ---------------------------------------------------- Report Manager Report Manager Autosave Add-in AutoSave Solver Add-in Solver Analysis ToolPak Data Analysis Conditional Sum Wizard Conditional Sum Lookup Wizard Lookup Template Wizard with Data Tracking Template Wizard Access Links MS Access Form Access Links MS Access Report Access Links Convert to MS Access
3.	On the Tools menu, click Add-ins.
4.	Click to select the `Add-In name` check box. Click OK.

Restoring the Commands That Are Not Created by Add-ins

Installing an add-in does not restore the following commands:

   Links
   Objects
   Custom Views
   Goal Seek
   Add-ins

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.

↑ Back to the top

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.

↑ Back to the top

References

For more information about customizing menu commands, click Microsoft Excel Help on the Help menu, type Customize menus and toolbars in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top