the button is missing - Launch Power Query Editor

Anonymous
2023-03-24T11:37:37+00:00

Have a good time. Please help with the following problem, I used to work on the Windows operating system, after that I switched to Mac.

Using excel Version 16.71 (23031200)

License: Microsoft 365 Subscription, but the button is currently missing - Launch Power Equery Editor.

What additional information can I provide you to understand this problem and how to solve it?

Microsoft 365 and Office | Excel | For business | 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 No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Bob Jones AKA CyberTaz MVP 430.2K Reputation points
    2023-03-24T13:43:43+00:00

    There is no separate button. Click the on the right edge of the Get Data (Power Query) tool at the extreme left end of the Data tab of the Ribbon.

    Alternatively, you also can launch it by opening the Data menu in the main menu bar.

    1 person found this answer helpful.
    0 comments No comments
  2. Anonymous
    2023-03-24T13:54:32+00:00

    Dear Anatoliy Kravtsev,

    Greetings! Thank you for posting in Microsoft Community. We are happy to help you.

    Per your description, the button Launch Power Query Editor is missing in Excel for Mac.

    We tried testing in Excel 16.71 on macOS Ventura 13.2.1. We can see the button Launch Power Query Editor in Data tab > Get Data(Power Query), as shown below.

    Image

    As mentioned in this article Shape data with Power Query Editor in Excel for Mac - Microsoft Community Hub

    Power Query Editor is now available in Excel for Microsoft 365 for Mac version 16.69 (23010700) or later.

    We notice that you have Excel version 16.71. If you still don't have the button, we're afraid it may because that the feature hasn't been released to your Microsoft 365 account.

    In the same article, it also mentions following

    Image

    You may try to install the Beta Channel build of Excel and check the result. For your reference:

    Welcome to the Office Insider for Mac community!

    If you still don't have the Launch Power Query Editor button in Excel, we do understand the inconvenience caused and apologize for it. We sincerely recommend you feedback this situation by clicking Help > Feedback. For reference: How do I give feedback on Microsoft 365? - Microsoft Support

    Feedback submit by this way directly goes to the related team, this is the best way to let Excel developers know your requirement and comments, help investigate the situation and fix it soon.

    Thanks for your time and cooperation! We hope you are keeping safe and well.

    Sincerely,

    Tina | Microsoft Community Moderator

    1 person found this answer helpful.
    0 comments No comments