• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 652
  • Last Modified:

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?
1 Solution
At first glance I'd not really expect it to be - after all, Office 2013 was 3 years in the the future when 2008R2 was released.

I believe that 2008R2 is noted by MS as being compatible with the .xlsx file format (unlike 2008, which only output to .xls files).

However, your app vendor may be doing something with SSRS that works fine when working with Office 2010 (exploiting what they maybe didn't realise was a bug) and now doesn't work with 2013 (bug fixed by MS). Of course, it could also been the other way around!

I'd suggest trying out going back to Excel 2010 on the machine that renders the reports and seeing how you get on.


apexcapAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now