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

ID: Q206938

The information in this article applies to:
  • 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 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 : kbdta xlpivot
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: July 7, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.