Share via

Get & Transform Option not Visible in Excel 365

Anonymous
2020-05-15T03:41:02+00:00

I recently purchased  office 365 and installed on Macbook. However, I can't see the option of Get and Transform Query / Power Query in the Data Ribbon.

Microsoft 365 and Office | Excel | For home | Windows

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

12 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2020-05-16T15:36:21+00:00

    Speaking of which, I should have mentioned that you can give a little boost to the developers working on the project by voting for the feature request and commenting on it in the feature request forum here:

    Add support for Get & Transform (formerly Power Query)

    Even as recently as yesterday, added functionality is in Excel for Mac. I can now change the file path of a query connection.

    0 comments
  2. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2020-05-17T02:41:10+00:00

    Hi,

    May be your version/build of MS Excel for Mac does not support Data > Get & Transform.

    1 person found this answer helpful.
    0 comments