I have a user whose Excel 2016 Power query editor is missing under Data Tab-> New Query -> Query Option. In the Query Option window, Under Global - here Power Query Editor should be listed but is missing. I checked the Addins, similars addins (compared with mine) are active, Microsoft Power Map for Excel. I have tried to re-install Office 2016 professional 64 bit, but still missing. Any idea will be helpful Query OPtions Thank you
4
-
Power Query has been integrated with excel starting with Excel 2016, so you should be able to just Data-> get data...– gns100Commented Sep 20, 2022 at 16:30
-
The user is unable to do certain tasks like her colleagues because of the missing Power Query editor option.– rakkshitCommented Sep 20, 2022 at 19:31
-
Did you try to update the Excel?– LeeCommented Sep 21, 2022 at 8:21
-
Hi, i installed Microsoft Office 2016 64bit Updates 2007 and problem solved. Thanks– rakkshitCommented Sep 21, 2022 at 10:29
Add a comment
|
2 Answers
Is the user sure they can't see this:
Or are you asking for something different?
Solution: Installed MIcrosoft Office 2016 64 bit 2007 updates - Check Excel Data tab -> New Query Option- the Power editor option is now available. Solved. Check in path "C:\Program Files\Microsoft Office\Office16\ADDINS\Microsoft Power Query for Excel Integrated\bin" Before update No of items were 77. After update No of items are 148.
-
As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.– Community BotCommented Sep 21, 2022 at 11:44