We recently upgraded Office 2007 Pro Plus to Office 2013 Pro Plus and have encountered an issue with the reporting piece in one of our applications. The third-party application runs on a server with Windows 2008 R2 Standard and SQL 2008 R2 Standard.
From within the application, users are given a variety of ways to view/export reports, one of them being to Excel. Since upgrading to Excel 2013, we now receive an error message when exporting certain types of reports (i.e. ones where multiple reports/spreadsheets are merged into one).
In working with the application vendor's support department, I was told that the version of SSRS is incompatible with Office 2013 applications. I'm not necessarily looking for a solution to the error from this forum, so much as I'm just trying to get some validation for this explanation. I haven't been able to find anything on the web that answers this specific question and I feel that this may be just one way for them to sweep this issue under the rug.
So, whereas there may not be a simple answer, the simple question is: Is SQL 2008 R2 SSRS compatible with Excel 2013?