XL2000: Parameter Names Lost When Publishing a PivotTable

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

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 this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: pivotlist XL2000

Keywords : kbdta
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug