We have used the SSRS ExcelOpenXML before and not had this issues. For some reason we are now getting the too many rows Excel 97 error. Can someone advise as to why this is happening? Or if there is a setting we are missing?

Exception in Task: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 401643. Maximum rows: 65536. ---> Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 401643. Maximum rows: 65536. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

We have used the SSRS ExcelOpenXML before and not had this issues. For some reason we are now getting the too many rows Excel 97 error. Can someone advise as to why this is happening? Or if there is a setting we are missing?

Exception in Task: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 401643. Maximum rows: 65536. ---> Microsoft.ReportingServices.ReportProcessing.HandledReportRenderingException: Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 401643. Maximum rows: 65536. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Hi,

Did the files/amount of rows or anything change since before? What version of visualcron are you using?

When we previously used it it was for files that were generating rows over the 65536. I can't confirm the exact number as they fluctuated over that threshold. That is why we used the ExcelOpenXML.

We are currently on version 9.8.0 Pro

When we previously used it it was for files that were generating rows over the 65536. I can't confirm the exact number as they fluctuated over that threshold. That is why we used the ExcelOpenXML.

We are currently on version 9.8.0 Pro

Please send an email to support@visualcron.com with a screenshot of the error (make sure extended task debug logging is enabled) as well as task settings. It would be great if you could provide a sample job+file as well so that we can reproduce from our environment.