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

View products that this article applies to.

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.

Back to the top

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.

Back to the top

Installing or Running an Add-In

Microsoft Excel cannot open <file name>. 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 <file name> is the name of the add-in you're attempting to install or run.

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top

REFERENCES

For more information about macro security, click Microsoft Excel Help on the Help menu, type Security levels in Excel in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Back to the top