Text Import Wizard May Not Run With Virus Search Add-In

Last reviewed: October 31, 1996
Article ID: Q158283
The information in this article applies to:
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel for Windows, versions 5.0, 5.0c

SYMPTOMS

When you open a text file in Microsoft Excel the Text Import Wizard may not run and your data will be opened, unparsed, into column A of your worksheet.

CAUSE

You may experience the above behavior if both of the following are true:

  • You are manually opening a text file.

    -and-

  • You have a version, other than version 1.2, of the Virus Search Add-In, Xlscan.xla, installed on your computer.

RESOLUTION

To resolve this issue so that the Text Import Wizard runs when you open a text file, remove your current version of the Virus Search add-in, obtain version 1.2 from the Microsoft World Wide Web site, and install this version on your computer:

  1. Uninstall the Virus Search add-in you currently have installed.

    a. Click Add-Ins on the Tools menu.

    b. In the Add-Ins dialog box, clear the check box for "Microsoft Excel

          Virus Search" and click OK.
    

    c. Exit Microsoft Excel.

    d. Delete the file, Xlscan.xla, from the \Msoffice\Excel\Library folder.

  2. Obtain version 1.2 of the Virus Search add-in, Xlscan.xla.

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q150990
   TITLE     : WE1280: Virus Search Add-in, Version 1.2 Is Available

  • Follow the directions that come with the latest version of the add-in to install this version on your computer.

    STATUS

    This problem was corrected in version 1.2 of the Microsoft Excel Virus Search add-in, Xlscan.xla.

    MORE INFORMATION

    To determine if version 1.2 of the Virus Search add-in is installed on your computer, in Microsoft Excel click Open on the File menu. Select any file that contains a macro and then click Open. If the title bar of the next dialog box does not contain "Version 1.2", you have a version other than 1.2. NOTE: The above steps for checking your version of the Virus Search add-in assume you have the add-in listed as installed in the Add-Ins dialog box in Microsoft Excel.

    When you have version 1.2 of the Virus Search add-in installed on your computer and you open a text file in Microsoft Excel, the following dialog box will appear:

       This file is a text file that does not contain a virus. To open this
       file using the Text Import Wizard, click OK, and in the Open dialog box,
       click OK.
    
       Because this Open dialog box does not provide virus protection, you
       can only open text files safely.
    
    
    and you can click OK or Cancel.

    If you click OK, the Open dialog box will appear. Click your text file and then click the Open button to start the Text Import Wizard. If you click Cancel, the Text Import Wizard will not run and your file will not be opened.

    For additional information on the Microsoft Excel Virus Search Add-In, please see the following articles in the Microsoft Knowledge Base:

       ARTICLE-ID: Q154131
       TITLE     : XL: Q&A about Excel Macro/Laroux Macro Virus
    
       ARTICLE-ID: Q154863
       TITLE     : MS Excel Virus Search Add-In Is Not Needed on the Macintosh
    

  • KBCategory: kbusage kbtool
    KBSubcategory: xladdins xlloadsave

    Additional reference words: 7.00




    THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

    Last reviewed: October 31, 1996
    © 1998 Microsoft Corporation. All rights reserved. Terms of Use.