Supported excel version for ssrs(SQL Server 2008)

Which is the minimum supported excel version for ssrs(SQL Server 2008)?

Thanks in advance.
mseitAsked:
Who is Participating?
 
ValentinoVBI ConsultantCommented:
When exporting report to Excel using SSRS 2008, the format used to create the Excel file is the old one, with the .xls extension (recognized as Microsoft Office Excel 97-2003 Worksheet).
0
 
lcohanDatabase AnalystCommented:
Or Excel 2007 - XLSX if you want to use the Office Compatability Pack that can be installed to take the xls files and turn them into xlsx files. You can download this program at
http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

0
 
ValentinoVBI ConsultantCommented:
As for minimum supported Excel version (which I understand as "what is the oldest version of Excel that should be able to open the generated Excel files"), you should be able to open the files using Excel 97.  

But that is something which I've never tried myself (I don't have 97 anymore :-)).
Any newer version of Excel will also open the files.
0
 
mseitAuthor Commented:
SOLUTION WAS NOT SURE.
0
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.

All Courses

From novice to tech pro — start learning today.