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 <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.
- You start Microsoft Excel.
-or-
- You attempt to install an add-in in the Add-ins dialog box.
- 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.
Additional query words: XL2000 macro virus xlm
Keywords: kberrmsg kbprb KB225078
