Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: XLDataSource Error Opening PivotTable Published from Excel List

XL2000: XLDataSource Error Opening PivotTable Published from Excel List

View products that this article applies to.

This article was previously published under Q221000

↑ Back to the top

Symptoms

When you open a Web page in Microsoft Internet Explorer that contains a Microsoft Office PivotTable list, you may receive an error message similar to the following:
The PivotTable list "PivotTable1" could not connect to the data source "XLDataSource". For information about the data source, consult the creator of the file.

0x800a6592: The "XLDataSource" object can not be found.

↑ Back to the top

Cause

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

    -and-

  • You created the Excel PivotTable from data stored in an Excel worksheet.

    -and-

  • The Save data with table layout check box in the PivotTable Options dialog box was not selected when you published the PivotTable.

↑ Back to the top

Resolution

To resolve the problem, follow these steps:
  1. Open the Excel workbook that was used to publish the Office PivotTable.
  2. Right-click the PivotTable, and then click Table Options.
  3. Under Data options, click to select the Save data with table layout check box and then click OK.
  4. On the File menu, click Save as Web Page. Click Publish.
  5. In the Choose list, click PivotTable. Click to select the Add interactivity with check box.
  6. Type the name of your file in the File name box, and then click Publish.

↑ Back to the top

Keywords: KB221000, kbpending, kbprb

↑ Back to the top

Article Info
Article ID : 221000
Revision : 3
Created on : 10/6/2003
Published on : 10/6/2003
Exists online : False
Views : 377