XL2002: Formulas Return #VALUE! or #NAME! After Upgrade (289841)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q289841

SYMPTOMS

After you upgrade to Microsoft Excel 2002, formulas in your workbooks may display #VALUE! or #NAME!.

CAUSE

This behavior may occur when your workbook uses functions that are provided by add-ins, and you upgrade to Excel 2002.

By default, Excel 2002 turns off all add-ins (on the Tools menu, click Add-Ins). Excel cannot recognize functions that are provided by add-ins if the add-in is not selected in the Add-Ins dialog box.

RESOLUTION

To turn on the add-ins, follow these steps:
  1. Start Excel.
  2. Open the workbook that contains the formulas that display the errors.
  3. On the Tools menu, click Add-Ins.
  4. In the Add-Ins dialog box, click to select the check boxes for the add-ins that the workbook uses.
  5. Click OK.
  6. Recalculate the workbook by pressing F9 or CTRL+ALT+F9.
Modification Type:MinorLast Reviewed:1/6/2006
Keywords:kbprb KB289841
©2004 Microsoft Corporation. All rights reserved.