Post reply

Export to Excel 2007

  • April 20, 2010 at 8:38 am

    #221552

    Hi,

    Can you export a report from SSRS 2005 to Excel 2007?

    I am unable to check myself as we do not currently run SSRS 2005 but need to know the answer to this question before we do implement it.

    Thanks.

  • April 20, 2010 at 9:14 am

    #1154675

    I don't believe so as I believe it only use's the 2003 rendering engine. Have you tried renaming the .xls output to the .xlsx?

    Let me know if you do find a solution, but I believe only SSRS 2008 will export to the Office 2008 format.

  • April 20, 2010 at 11:17 am

    #1154802

    Alasdair Thomson (4/20/2010)

    I don't believe so as I believe it only use's the 2003 rendering engine. Have you tried renaming the .xls output to the .xlsx?

    Let me know if you do find a solution, but I believe only SSRS 2008 will export to the Office 2008 format.

    Have successfully exported to Excel 2003, then opened with Excel 2007, now admittedly it was not a complex spread sheet, but it opened and was useable, when attempting to save to Excel 2007 format a warning is issued by Excel ""Microsoft Office excel recalculates formulas when opening files last saved by an earlier version of Excel"

    Test , export to Excel 2003 and check spread sheet using Excel 2007, this could be a work around for you. Then test again, and again with various reports.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply