SSRS 2008 R2 not exporting data to Excel 2016 #ssrs #oofice365 #ssrs2008r2 RRS feed

  • Question

  • Hi,

    After 0ffice 365 updates done. SSRS 2008 R2 not exporting data to Excel 2016. Please let me know, what changes need to be done inorder to export report to Excel 2016.


    Tuesday, March 6, 2018 10:14 PM

All replies

  • Hi VNJMSS,

    You said the SSRS report can't export to Excel, did you want it can't export to .xlsx file? If so, you could try to check the configuration file of SSRS to check whether the Excel and Excelopenxml is like below

    And you need to check whether the report exceed the max rows for Excel. You could refer to this link for details.

    In addition, when you can't export the report, did you get any error information? If there is , please inform me.

    Best Regards,
    Zoe Zhi

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, March 7, 2018 2:30 AM