Microsoft KB Archive/221000

= XL2000: XLDataSource Error Opening PivotTable Published from Excel List =

Article ID: 221000

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Office PivotTable Component 9.0, run time

-



This article was previously published under Q221000



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.



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.



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.

Additional query words: XL2000 pivotlist

Keywords: kbprb kbpending KB221000

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.