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

This article was previously published under Q225078
This article has been archived. It is offered "as is" and will no longer be updated.
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 <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.
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.				
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.
XL2000 macro virus xlm
Properties

Article ID: 225078 - Last Review: 10/20/2013 22:44:12 - Revision: 3.0

  • Microsoft Excel 2000 Standard Edition
  • kbnosurvey kbarchive kberrmsg kbprb KB225078
Feedback