Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170974

From BetaArchive Wiki
Knowledge Base

Article ID: 170974

Article Last Modified on 1/20/2007


  • Microsoft Office 97 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Word 97 Standard Edition

This article was previously published under Q170974


When you insert a Microsoft Excel workbook into a document in Microsoft Word 97 or in a Binder in Microsoft Office Binder 97, you may receive the following error message:

Microsoft Excel
The workbook you are opening contains macros. Some macros may contain harmful viruses. If you are sure this workbook is from a trusted source, click Yes. If you are not sure and want to prevent any macros from running, click No.

Note that you receive the same error message twice.

You may also receive the same error message once when you perform either of the following actions:

  • You switch to a Microsoft Excel workbook that is embedded in a Microsoft Word document.


  • You open an Office Binder that contains a Microsoft Excel workbook.


This problem occurs if any of the following conditions are true:

  • You insert a Microsoft Excel workbook that contains macros into either a Word document or an Office binder.


  • In Word 97, you switch to an embedded workbook that contains macros. -or-

  • You open a Binder that contains a workbook that contains macros.


To work around this problem, use one of the following two methods:

  • Remove all of the macros from the workbook before you insert it into a Word document or a Microsoft Office Binder.

  • Disable macro virus protection in Microsoft Excel 97. To do this, follow these steps:
    1. On the Tools menu, click Options.
    2. Click the General tab.
    3. Click to clear the "Macro virus protection" check box, and then click OK.
    NOTE: If you do this, you are not warned when you open a workbook that contains macros. This makes it possible for Microsoft Excel workbooks to become infected with macro viruses if you open a workbook that contains one. Use this option with caution.


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


The programs included with Microsoft Office 97 that support the use of Visual Basic for Applications macros also include macro virus protection. If this feature is selected, you receive a warning message whenever you open a file (such as a workbook or a document) that contains macros.

In some cases, you may receive a macro virus warning message twice when you open a file by using any of the following methods:

  • You open the file in the program that created it.

  • You insert the file into a document in another program.

  • You insert the file into a Microsoft Office Binder by clicking Add From File on the Section menu.

This behavior occurs because of the way in which the file is opened or inserted by the program you are currently using.

Additional query words: XL97

Keywords: kbprb KB170974