Microsoft KB Archive/292469

= Import Text File dialog box is displayed when you refresh external data in Excel =

Article ID: 292469

Article Last Modified on 6/23/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



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.
 * The data was imported from a text file.
 * 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) Excel 2002 and Excel 2003

On the External Data toolbar, click Data Range Properties.

Excel 2007

Click Properties in the Connections group of the Data tab.
 * 1) Click to clear the Prompt for file name on refresh check box.
 * 2) Click OK.

Additional query words: XL2002 prb XL2007 XL2K7 XL2003

Keywords: kbpending kbprb KB292469

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.