Forum Discussion
Run web queries
Hi, I am trying to import data from web but I have problems to use it. I am using an Excel version of Microsoft 365 on Mac. I have tried doing this without success: 1 st) Pate the url of ...
I'm having a similar problem.
I'm trying to do a Power (Web) Query on Excel for Mac.
I select the URL and I want to use to run the Query on and save it as an "iqy" file in my Queries Folder.
But when I go into Excel and execute Data/Get External Data/Run Web Query, my .iqy files are all greyed out and I can't select them.
Any idea on how to change this?
I have 2 Microsoft sample .iqy files in this folder which I can access, but these are just random samples put there by MS