Does anyone know if there is a limitation on number of rows when migrating using Excel Add-In?
I have done a few tests and it seems to be limited to 5000 rows??
Userlevel 1
+5
Hi
Userlevel 3
+10
Hi
Did you get an error message during your tests? If so, please provide that one.
+1
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.