title: How to load .iqy file into excel as datasource
body: <p>I'm having some data from a custom build sharepoint site, which only offers me access to the content by giving me and .iqy file for each category on the site.</p>
  <p>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).</p>
  <p>I've looked into excels &quot;Data&quot; section and also searched the web and the documentation of excel itself with no luck.</p>