Microsoft KB Archive/200708

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

Article ID: 200708

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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.



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:

 On the Tools menu, click Add-ins.  Click to clear the  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  On the Tools menu, click Add-ins. Click to select the  check box. Click OK.</ol>

Restoring the Commands That Are Not Created by Add-ins
Installing an add-in does not restore the following commands:

<pre class="fixed_text">  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.

<div class="moreinformation_section">

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.

<div class="references_section">