Article ID: 225078 - View products that this article applies to.
This article was previously published under Q225078
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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
Where <file name> is the name of the add-in you're attempting to install or run.
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.
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 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.