For a Microsoft Excel 2002 version of this article, see
291058.
For a Microsoft Excel 98 version of this article, see
192363.
For a Microsoft Excel 97 and earlier version of this article, see
121730.
RESOLUTION
To work around this problem, click
Add-Ins on the
Tools menu, and click to select the
Analysis ToolPak check box or the
Analysis ToolPak - VBA check box.
If the Analysis ToolPak is not available in the
Add-Ins dialog box, you may need to run the Setup program and reinstall the add-ins.
Note that for the change to take effect, you need to update each formula that references the add-in. To do this, use either of the following methods.
Method 1: Force Individual Formulas to Update
To force an individual formula to update, follow these steps:
- Select a cell that contains the error.
- Press F2, and then press ENTER.
Repeat these steps for any other formulas that have not been updated.
Method 2: Force Formula Updating by Replacing Equal Signs
To force all formulas to update, follow these steps:
- On the Edit menu, click Replace.
- Type = in the Find what box.
- Type = in the Replace with box.
- Click Replace All.
NOTE: This forces all formulas in the active worksheet and dependent formulas in other worksheets to recalculate.