Share via

Activating Power Query Editor in Excel for Mac

Anonymous
2022-06-24T23:51:22+00:00

According to this Microsoft Support page and various third party sources, Excel for Mac users should be able to activate Power Query Editor assuming they have opted into the Office Insider Program. I have followed these instructions to opt into the Insider program by setting my Update Channel to Beta, which apparently should enable me to download the additional features to activate Power Query Editor. However, after running Microsoft AutoUpdate, it says that Excel is fully up-to-date on my computer and there are no options for me to download these additional features.

Is anyone else running Excel for Mac experiencing similar issues? Has anyone found a solution?

I am running Microsoft Excel version 16.62. I have the most up-to-date version of Mac OS. According to all Microsoft documentation on this topic, I should be able to access these features, so I'm not sure what's going wrong.

Microsoft 365 and Office | Excel | Other | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

20 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-07-06T14:43:16+00:00

    Is your system set to US English?

    0 comments
  2. Anonymous
    2022-08-21T14:15:49+00:00

    The blog Neha linked above was very helpful. One of the tips said to sign out of your microsoft account. Close it all down. Log back in. This did the trick for me!

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-08-21T15:33:25+00:00

    Good morning.

    I have Excel for Mac, Version 16.64, with a MS Office 365 subscription. Installed on a new MacBook Pro in June. And I don't have the option to Open PowerQuery Editor. Has that moved from the office insider phase to complete rollout?

    ![](https://learn-attachment.microsoft.com/api/attachments/85f32064-0c3c-47a4-b65f-365764b63198?platform=QnA

    1 person found this answer helpful.
    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2022-08-21T23:17:29+00:00

    Please refer to your screen shot. The first menu option is Get Data (PowerQuery).

    This will open the Choose Data Source dialog. Choose a connector, then find the source file using the Browse button in the next step. Then click the Get Data button followed by the Next button.

    In the following dialog choose the tables you want in the left column, then click the Transform data button. This will open the PowerQuery Editor.

    When you've finished your query, click the Load button.

    Once you have your query result set you can re-open the PowerQuery Editor from the Data tab on the Ribbon.

    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2022-08-21T23:35:27+00:00

    Thank you. Unfortunately, I don’t think that helps. I’ve used PowerQuery enough to understand the basics pretty well.

    I’m working in an Excel workbook that already has a power query routine built. I created the workbook, and built the power query routine, on a Windows computer. Recently I upgraded to a MacBook. When I now open the workbook in Excel for Mac, and select the GetData drop-down, there is no option to open the Power Query editor so that I can modify my existing Power Query. Just what you see in the screenshot.

    And I do know for sure that the Power Query routine is there…I run it at least weekly.

    I hope that clarifies. I should have provided more info in my original post.

    Thanks again for the reply.

    0 comments