Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)4,029 votes
Hi all! We are happy to let you know that in addition to refreshing your data from supported sources, you can now import data from local files such as Excel workbooks, and Text and CSV files with Power Query in Excel for Mac. This new functionality is available to Beta channel users running version 16.50 (build 21050400) or later.
You can check out the blog for this new feature here: https://insider.office.com/en-us/blog/import-data-from-local-files-with-power-query-in-excel-for-mac
For more information about Power Query features that are currently supported in Excel for Mac, please take a look at the following support article: https://support.microsoft.com/office/7b2f337d-e7d2-4fdf-bf00-3dfbb1e5e9c5
Product Manager, Excel Team
What I love, please read this a need, is a better Name manager.
The size of the list is way to small. If you work a lot with names, then you get longer names which are not easy to select.
Also would like to see an easier way to replace, rename and exchange Names and references. When I make a Template sheet with names/reverences and want to make multiply copies bij code or manualy, its a crime to change or update the Name.202 votes
Hi All – the Name Manager is now available in Excel for Mac if you’ve opted into the Insiders program and chosen the Beta updates.
You can read more about it here, including the required version number – https://insider.office.com/en-us/blog/improved-name-manager-in-excel-for-mac.
For information about how to join the Insiders program – https://insider.office.com/en-us/join/mac
- Don't see your idea?