Click Document to filter all the recoverable Excel files. In Office 2011 for Mac, Excel can try to load tables from a Web page directly from the Internet via a Web query process. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Can I import data from an Excel .iqy file to a sharepoint list? How to open IQY files. Opening the .iqy directly with excels works by giving me a new excel sheet, but what I want to archive here is containing 3 different categories into 1 excel sheet and also have them automatically update whenever the sharepoint site receives any updates for the 3 categories(or when I click refresh). I think they are just plain text, so the likely issue is the .iqy extension is not associated with Excel Can you right click in windows explorer and choose to always open with excel? Press Windows+R key, type excel.exe /safe, and click "OK". Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. (see below) Troubleshooting. The motherboard in my laptop was replaced. When I click the button in the SharePoint ribbon, it allows me to download an OWSSVR.iqy file. What if developers don't want to spend their time on testing? Excel General; Cannot open .iqy file; Results 1 to 4 of 4 Cannot open .iqy file. (just to verify whether proxy authentication is causing this issue with Excel or something else possibly SharePoint itself). By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy. Then open Excel and Data->Import Data. Thanks so much for your reply.