Microsoft KB Archive/236990

= XL2000: Parameter Query Does Not Refresh Automatically =

Article ID: 236990

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q236990



SYMPTOMS
When you type a parameter for a Web or database query into a cell, Microsoft Excel does not refresh the query, even though you selected the Refresh automatically when cell value changes check box in the Parameters dialog box.



CAUSE
This problem occurs when the following conditions are true:


 * The cell that contains the parameter is located on a different worksheet from the query results.

-and-


 * You have saved, closed, and then reopened the file that contains the query.



RESOLUTION
To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

To temporarily work around this problem, follow these steps:  On the same worksheet that contains the query results, create a formula that links to the cell that currently contains the parameter used in your query. For example, if your parameter is located in cell A1 on Sheet2 in your workbook, the formula would be as follows:

=Sheet2!A1

 Select any cell within your query results. On the Data menu, point to Get External Data, and then click Parameters. In the Get the value from the following cell box, type =, where  is the cell in which you typed the formula that you created in step 1. Click OK.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

Additional query words: XL2000

Keywords: kbbug kbpending KB236990

-

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

© Microsoft Corporation. All rights reserved.