Excel 2016 For Mac - Get and Transform Data RRS feed

  • Question

  • Does Excel 2016 for Mac handle the Power query/ Get and Transform Data differently than windows?

    I built a query in Excel 2016 for windows using Get and Transform data and when I refresh, I see the status on the bottom task bar.

    On the Excel 206 for Mac, there is no Table Tools and Query Tools menu, just a Table menu with a refresh button, but the refresh doenst do anything.  I dont see it say "Running background query" on the Mac.  It doesnt seem like the right tools are installed

    What do I need to install to get it to work?

    Monday, May 28, 2018 9:55 PM


All replies