In most cases, when you first attempt to use a feature that is not installed, Microsoft Excel 2000 installs the feature automatically. For example, if you point to Get External Data on the Data menu, and then click Run Database Query, Microsoft Query is installed.
If the feature that you want is not installed automatically, follow these steps.
NOTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.
Quit all programs.
On the Windows Start menu, point to Settings, and then click Control Panel.
Double-click the Add/Remove Programs icon, and then do one of the following:
If you installed Excel with Microsoft Office, click Microsoft Office 2000 on the Install/Uninstall tab, and then click Add/Remove.
If you installed only Excel, click Microsoft Excel 2000 on the Install/Uninstall tab, and then click Add/Remove.
In the Microsoft Office 2000 Maintenance Mode dialog box, click Add or Remove Features.
In the Microsoft Office 2000: Update Features dialog box, select the feature and set its installation state as appropriate. For example, if you want to remove a feature, set it to Not Available.
When you are finished changing the installation states, click Update Now.
This procedure detects and repairs problems associated with installed Microsoft Office programs, such as registry settings and missing installation files. It does not repair personal files such as worksheets or templates.
To run Detect and Repair, use either of the following methods.
For more information about how to install or remove individual features of Microsoft Office or Excel, click Microsoft Excel Help on the Help menu, type install or remove in the Office Assistant or the Answer Wizard, and then click Search to view "Install or remove individual features of Microsoft Office or Excel".
For more information about automatically repairing Microsoft Office or Excel, click Microsoft Excel Help on the Help menu, type repair Excel in the Office Assistant or the Answer Wizard, and then click Search to view "Automatically repair Microsoft Excel".
For additional information about automatically repairing Microsoft Office or Excel, click the article numbers below to view the articles in the Microsoft Knowledge Base:
235620 OFF2000: How the Auto-Repairing Feature Works
230672 OFF2000: Differences Between Repair and Reinstall