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.

You are unable to use the release version of Excel 2007 to open an .xlsx file that contains a PivotTable if the file was saved on a computer that has 2007 Office Suite SP 1 installed


View products that this article applies to.

Symptoms

On a computer that has 2007 Microsoft Office Suite Service Pack 1 installed, a file that contains a PivotTable or another workbook data object is saved in the Excel OpenXML file format (.xlsx). When you try to open that file on a computer that has the release version of Excel 2007 installed, you are prompted to repair the file. Or, you are notified that the file is corrupted and that the file cannot be opened.

When you try to open a Microsoft Office Excel 2007 workbook, you receive the following error message:
Excel found unreadable content in Book_Name . Do you want to recover the contents of this workbook.
When you click Yes, you receive the following recovery report:
Removed Records: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)


This problem may occur if you have certain special formatting characters or if you are working with a PivotTable. Most Excel workbooks that contain a PivotTable are not affected by this problem.

Note The file may open correctly the first time that you open the file in the release version of Excel 2007. However, after you modify the file and then save it, you may experience this problem.

↑ Back to the top


Resolution

To resolve this problem, install 2007 Office Suite Service Pack 1 (SP1) and the Office Compatibility Pack SP1 on the computer that is running the release version of Excel 2007.

↑ Back to the top


Workaround

To work around this problem, use the computer that has Excel 2007 SP1 installed in order to save the file in the Excel 97-2003 Workbook (*.xls) file format. Then, transfer the .xls file to the computer that has the release version of Excel 2007 installed.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: KB943088, kbprb, kbexpertisebeginner, kbtshoot

↑ Back to the top

Article Info
Article ID : 943088
Revision : 3
Created on : 3/20/2008
Published on : 3/20/2008
Exists online : False
Views : 224