Microsoft KB Archive/225078

= XL2000: Errors When Trusted Resources for Add-ins Is Removed =

Article ID: 225078

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q225078



SYMPTOMS
When you start Microsoft Excel, open a template, or attempt to install or run an add-in, you receive one of the following error messages.

Starting Excel
This workbook contains a type of macro (Microsoft Excel version 4.0 macro) that cannot be disabled nor signed. Therefore, this workbook cannot be opened under High Security Level.

Installing or Running an Add-In
Microsoft Excel cannot open. There are several possible reasons:

- The file name or path does not exist.

- The file you're trying to open is being used by another program. Close the document in the other program, and try again.

- The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a     different name.

Where is the name of the add-in you're attempting to install or run.



CAUSE
These error messages occur when you do the following:


 * You set the Security Level for macros to High in the Security dialog box.

-and-
 * You clear the Trust all installed add-ins and templates check box, located on the Trusted Sources tab of the Security dialog box.

-and-
 * You do one of the following:
 * You start Microsoft Excel.

-or-
 * You attempt to install an add-in in the Add-ins dialog box.

-or-
 * You attempt to run a menu command for an add-in that has already been installed. See the "More Information" section for a list of these commands.



RESOLUTION
To be able to trust add-ins and templates and open them without error messages, follow these steps:


 * On the Tools menu, point to Macro and click Security.
 * In the Security dialog box, click Medium to change your macro security level, allowing you to choose whether or not to open files containing macros.

-or-

In the Security dialog box, click the Trusted Sources tab. Click to select the Trust all installed add-ins and templates check box. Click OK.



MORE INFORMATION
Some templates and add-ins contain Microsoft Excel version 4.0 macro code. This type of macro, also referred to as xlm, is stored in a macro sheet instead of a Visual Basic module. By clearing the Trust all installed add-ins and templates check box, you are attempting to prevent all macros stored in add-ins and templates from loading. Excel 4.0 macros cannot be digitally signed and cannot be opened with macro security set to the High setting.

Some add-ins for Microsoft Excel contain code written in the Excel version 4.0 macro language. These add-ins are listed in the following table:   Add-in Name         Menu       Command ---               ---

Solver Add-in      Tools      Solver

Report Manager     View       Report Manager

Analysis Toolpak   Tools      Data Analysis

Autosave Add-in    Tools      AutoSave

MS Query Add-in    N/A        N/A - Installs worksheet functions.

ODBC Add-in        N/A        N/A - Installs worksheet functions.

