Share via

excel power query on mac

Anonymous
2018-03-26T11:14:38+00:00

I do not have access to power query on my excel in mac. According to MS there is nothing to install and Power Query is accessable under the data tab.This is not my case. See print screen.

Microsoft 365 account

macOs Sierra

Excel: 16.11.1

How can I solve this problem. I searched under the developper tab. Add ins

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

Answer accepted by question author

Anonymous
2018-03-27T03:17:09+00:00

Hi Aldegondele Compte,

Power Query is not supported on Excel 2016 for Mac, please refer to the following article:

Where is Get & Transform (Power Query)

The Data tab you mentioned applies to Office 2016 on Windows.

This feature is currently planned by the Excel Team, refer to this UserVoice entry; we suggest you continue to vote for this feature via the link provided. We appreciate your understanding.

Regards,

Sheen

Was this answer helpful?

60+ people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2019-10-03T00:09:33+00:00

    Microsoft has provided updated information in this blog post

    Get & Transform (Power Query) in Excel for Mac - Phase 1 - Microsoft Tech Community - 876840

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments