XL2002: "Import Text File" Dialog Box Is Displayed When You Refresh External Data (292469)


The information in this article applies to:

  • Microsoft Excel 2002
This article was previously published under Q292469

SYMPTOMS

When you import data from a text file into Microsoft Excel, and then refresh the data, the Import Text File dialog box may be displayed unexpectedly.

CAUSE

This behavior can occur when all of the following conditions are true:
  • You attempt to refresh data from an external source.

    -and-
  • The data was imported from a text file.

    -and-
  • The Prompt for file name on refresh option is selected.

RESOLUTION

To prevent this dialog box from appearing, follow these steps:
  1. Start Excel, and then open the workbook that contains the external data.
  2. Click any cell in the external data section of the worksheet.
  3. On the External Data toolbar, click Data Range Properties.
  4. Click to clear the Prompt for file name on refresh check box.
  5. Click OK.
Modification Type:MajorLast Reviewed:6/26/2001
Keywords:kbprb KB292469
©2002 Microsoft Corporation. All rights reserved.