The. xlsx file that contains the PivotTable report can't open.

On a computer that has the 2007 Microsoft Office Suite Service Pack 1 installed, the file containing the PivotTable report is saved in the Excel OpenXML file format (. xlsx). When you try to open the file on a computer that has an Excel 2007 release installed, you are prompted to repair the file. Alternatively, the system will notify you that the file is corrupted and cannot be opened.

This problem may occur if your PivotTable report contains characters in certain special formats. Most Excel workbooks that contain a PivotTable report are not affected by this issue.

　　Note : When you open the file for the first time in an Excel 2007 release, the file may open correctly. However, you may experience this problem after you have modified the file and saved it.

Operation Steps:

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

Alternate method:

To work around this problem, save the file as an Excel 97-2003 workbook (*.xls) file format using a computer that has Excel 2007 SP1 installed. The. xls file is then routed to the computer that has the EXCEL 2007 release installed.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join