XL2000: Query Is Not Updated When File Is Opened (211624)
The information in this article applies to:
This article was previously published under Q211624 SYMPTOMS
When you open a file that contains a saved query, the query is not updated.
As a result, the region of the worksheet that contains the query is blank.
CAUSE
This problem occurs if the following conditions are true:
- You have saved a query in your worksheet.
-and-
- You click Refresh data on file open in the External Data Range Properties dialog box.
-and-
- You click Remove external data from worksheet before saving in the External Data Range Properties dialog box.
-and-
- You save the file in the Microsoft Excel 5.0/95 Workbook file format.
WORKAROUND
To work around this problem, follow these steps:
- Select a cell in the region of the worksheet that contains the query.
- On the External Data toolbar, click the Refresh Data button.
The worksheet is populated with the result set from the query. The
worksheet is populated with the result set from your query the next time
that you open the file. However, the query is not updated the next time you
open the file.
NOTE: The Refresh data on file open and Remove external data from worksheet before saving commands are not available in versions of Microsoft Excel before Excel 98. As a result, these features are not available when you save the file in the Microsoft Excel Workbook file format.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 11/5/2003 |
|---|
| Keywords: | kbbug kbpending KB211624 |
|---|
|