Get & Transform Option not Visible in Excel 365

Question

I recently purchased  office 365 and installed on Macbook. However, I can't see the option of Get and Transform Query / Power Query in the Data Ribbon.

Answer 1

Sorry! No Luck. Please see the attached screenshot.

Also, in the new version, they have stopped putting the name of the Tab under the ribbon (check my previous screenshot)

Answer 2

Last troubleshooting I can suggest is to open PowerPoint in safe mode:

An add-in or extension may be causing the problem.

To check, try to open PowerPoint in safe mode:

Right-click the Start button (lower-left corner) in Windows, and click Run.

Alternatively, you can press the Windows logo key and the R key on your keyboard.

In the Run box, type one of these commands:

Type powerpnt /safe, and click OK.

If Office applications works as expected in safe mode, disable the add-ins by following steps mentioned below and determine the problem causing add-in:

a) Click on File menu, click Options, Add-ins, Go button besides Manage: Com-in Add.

b) Check if there are add-ins listed, clear the checkbox.

c) Close the Office program and restart it.

d) Enable each add-in one at a time, restart the Office applications, and repeat the above procedure. If the issue reappears again, it will help you to determine which add-in is causing this issue.

Answer 3

Hi Lyn

I use a macbook. It doesn't have the options suggested by you. Have googled but could not find how to start Excel in safe mode on macbook.

Answer 4

Oh, my!

It seems Del is talking about Microsoft PowerPoint for Microsoft Windows. You're talking about Microsoft Excel. Perhaps it is too easy to get mixed up about which forum you're in here in the forums. Maybe there should be an icon that displays at the top of each question that makes it plain what product is under discussion. Perhaps something like this:

Anyway, let me try to return this discussion to Microsoft Excel.

Get & Transform is a feature that is fully supported in Excel for Windows. On the Mac, it is a new feature that is being gradually introduced. It will come in phases. Phase 1 is now in place:

Get & Transform (Power Query) in Excel for Mac - Phase 1 ...

As you can see from the date of this publishing, some time has passed. I would expect Phase 2 to come out pretty soon. What that will entail, I don't know.

Depending on your needs, you may not need PowerQuery to accomplish what you want to do. The grid in regular Excel is 1,048,575 rows by 16,384 columns. I realize that is no match for PowerQuery's billion and a half rows and two billion columns, but if your result sets will fit on the regular grid, you can use Microsoft Query to bring data sets into the traditional grid. So my first question is, will your result sets fit on the regular grid? If yes, you can use queries in Excel for Mac immediately without having to wait for PowerQuery.

If not, then you will have to wait until PowerQuery is rolled out. You can get a few months advance use of PowerQuery for Mac as it rolls out if you join the Office Insider Fast program. These are beta builds where Microsoft tests new features. PowerQuery is sure to be among them pretty soon. The hope is that you will try the new features and send feedback to Microsoft via the Smile button in the upper right hand corner of the workbook window. Doing so gives you a say in how the product will ultimately look and work.

Office Insiders - insider.office.com

Answer 5

I apologise for the inconvenience. I mixed up OS in your issue.

I hope Jim's response gives you clarification on this matter. You may join Office Insider or you may revert back to the previous office version installed on your mac from a Time Machine Restore.