Forum Discussion
Get & Transform missing
Hi All,
Get & Transform (Obtenir & transformation in french) is missing in my toolbar.
I can't load data from an existing table anymore.
How do I re-activate that Power Query functionnality?
Thank you
5 Replies
When you look under COM Addins are they still listed?
From the Excel Ribbon, choose File→Options. Choose the Add-Ins option on the left, and then Presume you did take a look for the Manage drop-down list at the bottom of the dialog box. Select COM Add-Ins and then click Go and checked they are still selected as active to load on start?
Look for the Power Query for Excel in the list of available COM add-ins. If they're not listed here then the DLLs are gone from your machine or not registered, ask a colleague or friend under the ADDINS folder you can just copy the DLLs to your machine shutdown excel reopen, follow the above instructions and select that should get them back.
Gavrea , Excel 2013 has no Get & Transform, it appeared in 2016 instead of Power Query add-in.
PierreD375 , on which version of Excel you are?
Thankyou! Your question made me realise that for some reason I wasn't using 365 like I thought I was but 2013 professionnal instead.
**bleep**.
Thank you for your help!
PierreD375 , yes, for 2013 you shall activate it in options->Add-ins->COM or reinstall.
You are welcome.
