I'm trying to look for the "New Query" button from the Get & Transform group in the Data ribbon but it isn't there.
What I see is this instead:
new query missing.PNG
I don't see New Query in the Customize Ribbons option either.
How do I display that button?
Power Map, Power Pivot and Power View add-ins are installed.
I am seeking to use the Power Query functionality and I need the "New Query" button there
Last edited by Cheesecube; 04-04-2018 at 04:05 PM.
Hi Cheesecube,
The newer version of Excel doesn't have a New Query button. Watch the first few minutes of:
https://www.bing.com/videos/search?q...1&&FORM=VRDGAR
To start a new query you simply get a new dataset.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Capture.JPG
I'm finding it in the Options section.
Your profile indicates Excel 2016. Are you using 365 as noted by Marvin. If so, update your profile.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
How do I load it in the Query Editor by default?
new query missing2.PNG
nope don't see New Query here...
Ok got it, all I had to do was click Edit on the data display screen
Please update your profile to reflect the correct version of excel you are using. See my post #3
Could you explain how you got it. I am trying to figure it out, but can't manage to find it.
Get Data | From Other Sources | Blank Query.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks