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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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