SharePoint List to Excel resulting Web query file

Help Activities
, ,
3

Hi @Robotman

Can you try the below?

Just save the iqy file locally and then point to the iqy file in the Excel Application Scope. Then you can use Read Range to pull the table. Usually it should automatically refreshes the query every time we run it.

Note: Based on the data load/no.of records, there might be a delay in response from server.

If this is not working, try whatever @kirankumar.mahanthi1 mentioned.

Hope this will be helpful. Thank you.

4 Likes