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.

XL2000: "File May Be Damaged or Missing" Error Opening PivotTable Published from Excel List


View products that this article applies to.

This article was previously published under Q205677

↑ 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:
An error occurred while trying to open the data file "./Published filename_files/Excel filename_9225_cachedata.xml". The file may be damaged or missing. Consult the creator of the Web page.

0x800a65c7: The name Field name contains invalid characters.
where Published filename is the name of the Web page that you are trying to open, Excel filename is the name of the Excel file used to publish the Web page, and Field name is the name of the field that contains an invalid character.

This error message may appear more than once. When the Web page loads, the PivotTable displays the following error message:
Unable to connect to data

↑ 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-

One of the field names in the list that was used to create the Excel PivotTable contains a period (.).

↑ Back to the top


Workaround

To work around the problem, follow these steps:
1.Open the Excel workbook that was used to publish the Office PivotTable.
2.Remove the period from the offending field name in the list that was used to create the PivotTable.
3.Select a cell in the Excel PivotTable that was used as the source for the Office PivotTable.
4.On the Data menu, click Refresh Data.
5.If you receive the following message
The Refresh Data operation changed the PivotTable Report.
click OK. You need to add the changed field back to your PivotTable. To do this, drag the field from the PivotTable toolbar to the appropriate drop area on the PivotTable.
6.On the File menu, click Save as Web Page. Click Publish.
7.In the Choose list, click PivotTable. Click to select the Add interactivity with check box.
8.Type the name of your file in the File name box, and then click Publish.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in Microsoft Office PivotTable Component, version 9.0.

↑ Back to the top


Keywords: KB205677, kbprb

↑ Back to the top

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