XL97: Opening Lotus 1-2-3 File May Run Macro Without Warning

• Microsoft Excel 97 for Windows

SYMPTOMS

When you open a workbook in Microsoft Excel 97, a macro from a non-trusted source may be run automatically.

CAUSE

This problem occurs when the following conditions are true:

• The workbook has been saved in the Lotus 1-2-3 or Quattro Pro file formats.
  
  -and-
  
  
• The workbook contains a Lotus 1-2-3 macro that is set to run automatically when the workbook is opened.

RESOLUTION

To resolve this problem, download and install the Excel 97 SYLK File Security Update. For additional information about how to obtain and install the Excel 97 SYLK File Security Update, click the article number below to view the article in the Microsoft Knowledge Base:

Q242209 XL97: How To Obtain and Install the Excel 97 SYLK File Security Update

MORE INFORMATION

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

If you need to enable the Macro Interpreter after you install the Excel 97 Auto Execution Update, follow these steps:

1. On the Windows taskbar, click Start, and then click Run. Type the following command in the Open box

   path/xl8p7pkg.exe /t:c:\test /c

   where path is the complete path to the directory in which you downloaded the file.



2. Click Yes to accept the license agreement.
   
   All of the files contained in the xl8p7pkg.exe file are extracted to C:\Test.



3. Double-click Xl8lmi.exe.



4. Click Yes when you are asked if you would like to re-enable the Macro Interpreter (MI).



5. Click Yes to accept the license agreement.



6. Click OK when you see the message that indicates that your system has been updated successfully.

HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel\EnableMacroInterpreter

Additional query words: XL97 execute

Keywords : kbdta xlloadsave xl123Quattro
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug