Microsoft KB Archive/943088

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

Article ID: 943088

Article Last Modified on 11/7/2007

-

APPLIES TO


 * 2007 Microsoft Office Suite Service Pack 1
 * Microsoft Office Excel 2007

-



SYMPTOMS
On a computer that has 2007 Microsoft Office Suite Service Pack 1 installed, a file that contains a PivotTable 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.

This problem may occur if you have certain special formatting characters in your 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.



RESOLUTION
To resolve this problem, install 2007 Office Suite Service Pack 1 on the computer that is running the release version of Excel 2007.



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.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertisebeginner KB943088

-

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

© Microsoft Corporation. All rights reserved.