XL2000: Parameter Names Lost When Publishing a PivotTable (210752)



The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Office PivotTable Component 9.0, run time

This article was previously published under Q210752

SYMPTOMS

When you open a Web page that contains a Microsoft Office PivotTable list, you may be prompted to enter one or more parameters. The parameters listed in the Enter Parameters dialog box do not match the name that you assigned to the parameters in your query.

CAUSE

This problem may occur when the following conditions are true:
  • You published the PivotTable list using the results of a query.

    -and-

  • The query is stored on a Microsoft Excel worksheet.

    -and-

  • You defined one or more parameters in the query.

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 kbpending KB210752