Knowledge Base

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

Article ID: 206938

Article Last Modified on 10/7/2003


APPLIES TO


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.

Additional query words: XL2000 pivotlist login log on

Keywords: kbprb KB206938