Im exporting sharepoint list to excel using the built in export in modern site. After exporting the list it named query.jqy,
I click enable then follow the signin for the data connection, but unfortunately some of the users are automatically closed the excel application after signin or there is an error that the existing version of the excel is not compatible.
1. Is this related on the excel version?
2. What patch do i need to be able to run or be compatible with our organization excel application.
3. Is there a settings that needs to be setup in list settings or in SharePoint administrator side for exporting file?