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 =Cell Reference,
where Cell Reference is the cell in which you typed the formula that you created in step 1.
- Click OK.