Answered by:
Power Query for Excel 2016 for Mac

Question
-
I had posted a question about how to transform data in my Excel sheet and had a great solution using Get and Transform data on Excel 2016 for Windows:
https://social.technet.microsoft.com/Forums/office/en-US/b1fe131a-ac7d-4681-80e1-074408986947/pivot-table-with-actual-values-instead-of-aggregates?forum=excel
I need this to work on Excel 2016 for Mac and just learned that power query is not supported on Macs.
Excel for Macs does recognize the tables, but cannot refresh them with source data.
How do i get around this to work on Excel 2016 for Macs?
Thank you
Answers
-
Hi,
In my opinion, use code to generate the determine table will be the best way for you use in both Office for Windows and MAC.
Please ask your requirement to Excel for Developer forum:
https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Regards,
Emi
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.- Proposed as answer by Emi ZhangMicrosoft contingent staff, Moderator Tuesday, June 5, 2018 6:33 AM
- Marked as answer by JHarding08 Tuesday, June 26, 2018 6:33 PM
All replies
-
-
I guess I am just looking for the simplest approach to solving the initial requirement from https://social.technet.microsoft.com/Forums/office/en-US/b1fe131a-ac7d-4681-80e1-074408986947/pivot-table-with-actual-values-instead-of-aggregates?forum=excel
that will work on Excel 2016 for Mac. The resulting dataset needs to be in the same excel workbook as the source data
-
-
Hi,
In my opinion, use code to generate the determine table will be the best way for you use in both Office for Windows and MAC.
Please ask your requirement to Excel for Developer forum:
https://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev
The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
Regards,
Emi
Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.
Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.- Proposed as answer by Emi ZhangMicrosoft contingent staff, Moderator Tuesday, June 5, 2018 6:33 AM
- Marked as answer by JHarding08 Tuesday, June 26, 2018 6:33 PM
-
Hi,
We just released the first stage of Power Query support on Mac. Please refer to the following blog post for more details:
Guy Hunkin - Excel Team