Aug 05 2019 09:59 AM
Hello,
Recently switched to Macbook, I notice that the Excel environment is slightly modified compared to the Windows interface.
I have a problem with this upheaval. Indeed, I was using requests from web sources. But on the mac I can't find any tab to check the sources already present in the document, or even to modify them....
I looked in the preferences, but I didn't find anything.
Do you have any idea how to reach it?
Thank you in advance!
Nb : I have the latest Excel's version
Aug 05 2019 11:00 AM
Solution
Hi,
Power Query is still not supported on Mac, but the good news is that the Excel team is planned to support it soon according to this idea.
Regards
May 18 2021 06:11 PM
Do you know when exactly Power Query will be available for Mac? It looks like it is in the works according to your post, but eager to know some times! Must learn this tool.
May 19 2021 10:56 AM
It goes forward by small steps, the latest one Import data from local files using Power Query in Excel for Mac - Microsoft Tech Community
I don't think that PQ for Mac will ever have same functionality as other versions (PQ for Excel, PQ Online, etc, they are all some different), but hope at least basic functionality will be in nearest future.
May 24 2021 08:17 AM
May 24 2021 01:34 PM
Please check How to Get Stock Quotes From Yahoo Finance Using Power Query - HowtoExcel.net , web query in your demo is outdated.
Jun 03 2021 06:43 AM
Jun 03 2021 08:39 AM
In general, Office 2019 is not feature updated version, that's only Office 365 has feature updates on regular basis. Next feature update for Office 2019 will be with Office 2021.
As for the platform, only Office on Windows has full functionality. Power Query on Mac has very very limited functionality, but it's slowly improved.
Aug 05 2019 11:00 AM
Solution
Hi,
Power Query is still not supported on Mac, but the good news is that the Excel team is planned to support it soon according to this idea.
Regards