Allow interaction with Excel while in Power Query
Please make the Power Query editor window (Get Data) non-model. When building complex queries, we often need to go back to Excel to change a worksheet and look at data. Right now, the Power Query editor window takes control over the application, preventing interaction with Excel.
The current behaviour makes it very difficult to do things like the following:
-Mid query, go back and check a worksheet to see exactly what a cell value may be that you want to refer to
-When we have a static table in Excel and are trying to build a query that lands an output in that shape, we can't hop back and forth and check how close we are
In the current implementation, we must close & load the query, check what we need, then re-open the query. Alternately we need to take a screen shot of the needed, or open a second Excel process in order to allow interaction. None of these are good solutions.
Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.
Chris C commented
MS must literally build Excel and then never use it for any application ever, do absolutely no testing and or user groups at all. How on Earth do your UI/UX folks allow this experience to pss their QA/QC?
It is so frustrating to have to save something and then close and then go check something it makes absolutely no sense and Guy Hunkin's response is frankly insulting, you don't have enough time to do a simple quality of life feature? At the very least it shouldn't impact AN ENTIRELY DIFFERENT WORKSHEET. Just ridiculous.
I can't beilive i read this answer from MS.
Did you guys try to work with PQ in Excel at all?!
Alex Dupler commented
Can we at least get the ability to SAVE the .xlsx without closing the PQ window so you can save mid-way through developing a query?
Omg, this is so foolish. I have to open Excel file in Google Sheets in order to read specs for my PQ output. It doesn't even allow a separate Excel application instance to run. I might as well look for better product, it will take 12 years for you to fix this. Good lock, stay safe!
Over two years and we still don't have this. It's still back in the dark ages for this where you could only run one program at a time. Screenshots or handwritten notes really should not be needed in this day and age but it is the only way of seeing the data file and the query at the same time!
And please, with the Online version. Why is there this rediculous issue of 30Meg file size? My company use the online version to capture data and after a year the file size is at 27 Meg. If we reach 30 we might as well get rid of our whole system and move to Google. And not to mention not able to lunk files. WTF....
Sam Vanderslink commented
This would likely solve the issue of having to alt+tab twice to get away from the PQ editor window.
Would love this. Currently get around it by snipping pictures, or padtinf vales into word or one note. Very clumsy.
Argenis Chaffardet commented
It’s important, so yes please, we are wasting time going back every time.
Yes please! Just like in Power BI!
Edgard Stultjens commented
Yes please: Excel Power Query frustration #1!
This annoys me every single day. Please fix it.
This has always been very frustrating
Imke Feldmann commented
Please implement this feature.
I often find myself wanting to check or adjust figures from the workbook.
Opening the file in a 2nd instance will mean read-only mode, so adjustments are not possible.
So obvious, it actually hurts it's not like that. I agree with previous reactions: PowerPivot allows it, it should have been working like this from day 1, we should not be asking this.
Thank you Ken for putting this on the user voice.
Why on earth do you, MS, feel that this is something that "could be quite useful"??? This is something that we shouldn't have to ask for. This is not a "nice to have" or an "improvement opportunity". This is a defect and should be treated accordingly.
I know you have so many legitimate defects that it is likely overwhelming however, that is your own fault.
Please fix your defects, many, if not most, of which worked correctly in prior versions; STOP focusing on your ridiculous, flawed, useless Online program versions. PLEASE. We beg of you. Implore you, even.
João Santos commented
100% agree. Power Pivot allows it.
Should never be necessary, but wanted to pass along a work around I picked up.
You can launch a separate instance of Excel by holding the ALT key as you select the Excel link on the Task Bar. I have found it does not always react to the held ALT key and sometime requires multiple attempts.
Don't know what I would be doing if I didn't have this work around.