This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi Ashish,
I am Lyn, an Independent Advisor and a fellow Microsoft user. Here to assist you in solving an issue.
May I know the version of Excel 365 installed in your Mac?
Open Excel.
Go to Excel > About Excel
Hi Ashish,
I am Lyn, an Independent Advisor and a fellow Microsoft user. Here to assist you in solving an issue.
May I know the version of Excel 365 installed in your Mac?
Open Excel.
Go to Excel > About Excel
Hi Lyn
It is 16.37 and I purchased it last month from MS store. Therefore, i believe that it must be the latest one.
Yes it is the latest build.
To refresh queries generated from Text, CSV, XLSX, XML or JSON files, please perform the instructions provided in the link to update Refresh command.
https://www.sumproduct.com/news/article/get-tra...
Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.
Sorry, i m not sure if I got it right. In the earlier version, I had a data table. I used to click on Data ribbon, an in the "Get and Transform" Tab , I used to select the "From Table/Range".
I went though the link you shared and refreshed as suggested. But there is no help on how to build the power query from the table.
Let's try to look for it under Customized Ribbon.
Go to File > Options > Customize Ribbon > Choose commands from: Commands not in the ribbonn. Look for that missing tab. Click Add.
Also try Under Customize Ribbon > Under Main Tabs, check and uncheck Data. Click OK.