Share via

Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536

Ashok Dubey 0 Reputation points
2024-06-06T13:49:36.94+00:00

Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,878 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 35,556 Reputation points
    2024-06-07T01:53:53.99+00:00

    Hi @Ashok Dubey,

    The max rows for current Excel is 1048576 which should meet your requirement.

    User's image

    In order to get around the 65536 row issue, you need to pass "EXCELOPENXML" instead of "EXCEL".

    You may follow this blog to set the report export to EXCELOPENXML.

    Remember to back up the rsreportserver.config file before you edit it.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 comments