Microsoft KB Archive/231141

= XL2000: Enter Parameters Dialog Box Is Blank When You Load Your Web Page =

Article ID: 231141

Article Last Modified on 10/7/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Office PivotTable Component 9.0, run time

-



This article was previously published under Q231141



SYMPTOMS
When you open your Web page in Internet Explorer, the Enter Parameters dialog box is displayed. However, the dialog box is blank and you are unable to enter the parameters necessary to populate the Microsoft Office PivotTable control on your Web page. When you click Cancel, the PivotTable control displays the following error message:

Query failed.



CAUSE
This problem occurs when the following conditions are true:


 * The PivotTable list was published using a PivotTable or a list stored on a Microsoft Excel worksheet.

-and-


 * The source data for the PivotTable list is stored in a Microsoft Access database.

-and-


 * The query used to retrieve the data from the Access database requires the use of one or more parameters.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000 pivotlist

Keywords: kberrmsg kbbug kbpending KB231141

-

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

© Microsoft Corporation. All rights reserved.