One of my client is using sharepoint 2016 and he wants to export the sharepoint 2016 list to excel, so From couple of days, i'm facing issue of exporting sharepoint 2016 list to excel using there export to excel feature. It's working fine with downloading the .iqy file, but when I open it, it prompted me to sharepoint login page, till now it's all good. It open the client login page that they use to login the user into sharepoint. The user can login with two ways, one is window authentication for there employees and one is form based. so when i try to login with my credentials, it keep opening the login page again and again.
I tried to open it using from web feature of excel where we need to give URL to it, and in that when login using organizational account, it open the same login page and i login again, it logged me in and when i press connect it giving me error the credential are invalid, but it says you are signed in, then i click on anonymous user and it keeps me import the list to excel using anonymous login. Can anyone help me out with this how i can make it work with .iqy file.