Error using Excel Services for SharePoint 2007 to open Excel workbooks created with Excel 2013


Issue

 

This has been reproduced with Excel 2013 and SharePoint 2007 SP3.

 

There is an issue with using Excel Services for SharePoint 2007 to open Excel workbooks that were created with Excel 2013.

 

If you attempt to open an Excel workbook in the browser that was created with Excel 2013 using Excel Services for SharePoint 2007, you will get an error like this saying that the workbook may be in an unsupported file format, or it may be corrupt”:

 

 

Cause

 

UPDATE: The issue is a side-effect of changes/enhancements that were made to the XML for .xlsx files for Excel 2013, which are not present in Excel 2007 or Excel 2010 files.

 

Workaround

 

This issue does not exist for workbooks that were created with Excel 2007 or with Excel 2010.

 

Excel Services for SharePoint 2013 will open workbooks that were created with Excel 2007, Excel 2010, or Excel 2013.

Comments (3)

  1. Chris says:

    And what is the solution?

  2. Kevin says:

    Hello… solution???

  3. MichielD says:

    Here the same issue. SharePoint 2007 KPI’s and Excel Services, but with Excel 2013. This can give the error "An error occured." and then nothing.
    Even saving as .xls with Excel 2010, then saving back as .xlsx with 2010.

Skip to main content