Article ID: 928613
Article Last Modified on 10/15/2007
APPLIES TO
- Microsoft Office Excel 2007
SYMPTOMS
When you try to run a macro in an encrypted workbook in Microsoft Office Excel 2007, the macro does not run. Additionally, you receive the following message:
To determine the unique number that is associated with the message that you receive, press CTRL+SHIFT+I. The following number appears in the lower-right corner of this message:
RESOLUTION
To resolve this issue, upgrade the antivirus program that is installed on the computer to a program that supports the scanning of encrypted content. Microsoft Antivirus API supports the scanning of encrypted content.
WORKAROUND
To work around this issue, do not save the workbook as an Excel Macro-Enabled Workbook (*.xlxm) file or as an Excel Binary Workbook (*.xlsb) file. Instead, save the original workbook as an Excel 97-2003 Workbook (*.xls) file.
To do this, follow these steps:
- Create the original encrypted Excel workbook in Excel 2007, but do not save the workbook.
- Click the Microsoft Office Button, and then click Save As.
- In the Save As dialog box, click Excel 97-2003 Workbook (*.xls) in the Save as type box.
- Name the file, and then click Save.
Note When you close and then reopen the encrypted workbook, the macro functions as expected.
MORE INFORMATION
For more information about encrypted files and the scanning of encrypted content in the 2007 Microsoft Office programs, click the following article number to view the article in the Microsoft Knowledge Base:
927150 A macro that is contained in an encrypted Office Open XML file does not run in 2007 Office programs
Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12 101644
Keywords: kberrmsg kbtshoot kbprb kbexpertisebeginner kbofficealertid KB928613
