asked on

SQL 2008 R2 SSRS and Excel 2013

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?

ASKER CERTIFIED SOLUTION

DcpKing

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

apexcap

ASKER

I haven't had a chance to try it with Excel 2010 yet, but am running into other macro-related issues with Excel 2013 so I may have to go back to a previous version regardless. And you're probably right about the vendor doing something with SSRS that's conflicting with 2013, so we'll probably just have to wait until they release an update. In any case, thanks for the response.