XL2000: Enter Parameters Dialog Box Is Blank When You Load Your Web Page (231141)


The information in this article applies to:

  • Microsoft Excel 2000
  • 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.
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbbug kberrmsg kbpending KB231141
©2003 Microsoft Corporation. All rights reserved.