question

sanjeev.matte avatar image
sanjeev.matte asked

Exporting a report to different Excel versions

Hi, I have Excel-97 and Excel-07 in my PC and i am working with SSRS 2008R2.when i export a report to the Excel by default it exports to Excel-07 which is a latest version.But i want the report to be exported to the Excel-97. Thanks for your help in advance.
ssrsexcelexport
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Kev Riley avatar image
Kev Riley answered
SSRS 2008R2 exports Excel files in a format that is compatible with MS Excel 97 and later. What exactly are you getting that is Excel 2007?
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sanjeev.matte avatar image sanjeev.matte commented ·
Hi Riley, i exactly want to export my report to excel-97 as i have both Excel-07 and Excel-97 exists in my PC.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Yes, the file you will get is an .xls file which will be Excel-97 compatible - can you not open it in Excel 97?
0 Likes 0 ·
Sacred Jewel avatar image
Sacred Jewel answered
One lucky person you are. I am amazed if you can get the export in 2007 format. AFAIK, this is not possible yet with 2008 R2 (At least for us). I heard that could be a feature in SQL Server 2012.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.