none
Spreadsheet with Power Query will it run on a Mac? RRS feed

  • Question

  • Do you know if I work an Excel 2016 spreadsheet using Power Query on Windows, can be viewed and the tables will work on a Mac/Apple? Thanks for helping me with this question.


    Saturday, September 9, 2017 1:49 PM

Answers

  • The output table will be viewable and editable, but you won't be able to refresh and the connection driver won't be recognized. Similar to what happens when a table has a broken link.
    Saturday, September 9, 2017 9:24 PM

All replies

  • The output table will be viewable and editable, but you won't be able to refresh and the connection driver won't be recognized. Similar to what happens when a table has a broken link.
    Saturday, September 9, 2017 9:24 PM
  • Hello,

    Is this still the case? Microsoft has recently updated to allow a full refresh in Excel for Mac, workbooks with Power Query queries can now be refreshed. I still can't refresh my workbook though, a popup appears asking me to rebuild the data combination. This only happens on Mac, is there something I'm missing? 

    Monday, November 2, 2020 3:57 PM