Hi @stbjno , there is not limitation on number of rows in Excel Add-in. 

Hi @stbjno,

Did you get an error message during your tests? If so, please provide that one.

I get an error message when trying to load data. Error message is saying: “The operation failed because multiple workbooks are open and the workbook being called by this API has lost focus”.

I know there are more than 5000 rows in the table to fetch from, but it looks like the operation is timing out or so. It stops at exactly 5000 rows every time.

This could be an issue with Microsoft excel add -in related.

Error handling with the application-specific JavaScript APIs - Office Add-ins | Microsoft Learn

Can you please check from your end focusing on description of this error