Power Queries in Excel For Mac
Power queries are one of the excellent tools that was introduced into Excel in the last few years and Microsoft are expanding their functionality regularly.
Applying them in the PC version is straight forward - but what about Mac Excel users? There's no sugar-coating it - it's a little more convoluted! Microsoft - if your listening - why is the Mac journey in Excel peppered with these hurdles?
There are query files with an iqy extension that are accessible from Mac Excel. We need to open one of these in Microsoft Word (or some other text editor) and edit the URL line to whatever url we need. This video takes you through the process step by step.
One note - when edit your iqy file and resave for the first time and then go to run it, the file will be disabled or greyed out. Just go back into the menu and click "Run Web Query" option a second time and it's enabled. It's just a bug that hopefully will soon be a distance memory for Mac users.
Subscribe to @QVisible for more tech tutorials.
Watch video Power Queries in Excel For Mac online without registration, duration hours minute second in high quality. This video was added by user Q Visible 19 May 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 74,741 once and liked it 196 people.