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

ID: q225078

The information in this article applies to:


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.


These error messages occur when you do the following:


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


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. 


For more information about macro security, click Microsoft Excel 2000 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.

Additional query words: XL2000 macro virus xlm

Keywords          : kberrmsg 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 25, 1999