XL2000: Opening Web Page Containing PivotTable Prompts for User Name and Password (206938)



The information in this article applies to:

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

This article was previously published under Q206938

SYMPTOMS

When you open a Web page that contains a Microsoft Office PivotTable list, you are prompted for a user name and password.

CAUSE

This problem occurs when the following conditions are true:
  • You published the PivotTable list using a PivotTable stored on a Microsoft Excel worksheet.

    -and-

  • To build the Excel PivotTable, you connected to an external database that requires a password.
When you publish a PivotTable list, Excel does not save passwords in the HTML files that it creates.

Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbprb KB206938