Ken Puls and Miguel Escobar just released their new Power Query book – Master Your Data with Excel and Power BI. I bought a digital copy, downloaded the sample files, and eagerly dove into the book. Then I remembered the problem I’ve had for a few months – the Excel Queries & Connections pane is stuck at the top of my second monitor. Here’s how I finally fixed it.
Here’s the Problem Pane
This is what the Queries & Connections pane looked like, every time I used it. It’s about 1 inch wide and tall, with no title bar showing. At the top, only the two tabs are showing – Queries, and Connections.
Fortunately, I was able to resize the pane, by dragging the sides or corners. That let me see what was in there!
I couldn’t move the pane though, because there was no title bar to double-click or drag.
Ignoring the Problem
Most of the time, I’m using existing queries, and don’t need to do anything with the Queries & Connections pane. It’s easy to just ignore a problem like that, instead of trying to fix it.
But, with Power Query experiments to try, I decided to tackle the problem.
Unfortunately, a Google search didn’t turn up any solutions. In fact, I didn’t find anyone else reporting the same problem.
Second Monitor Problems
Finally, I remembered a similar situation, when Excel UserForms suddenly looked strange on my second monitor. Maybe the second monitor display settings were affecting the Queries & Connections pane too.
Here’s what I did to temporarily change the monitor settings, to see if that would help:
- Right-click on an empty spot in the monitor
- Click Display Settings
- Changed the Scale and layout size from 125% to 100% (recommended setting)
Title Bar Appeared
As soon as I did that, the Queries & Connections pane shifted a bit, and its title bar appeared. Woohoo!
I was able to drag the pane down a couple of inches, so it wasn’t right at the top of the second monitor any longer.
I was also able to double-click the pane’s title bar, so it docked at the right side of the Excel window. Maybe I’ll leave it there for now, so the same problem doesn’t happen again!
Then, I changed the second monitor display settings back to 125%, so things are easier for me to see.
Get the Power Query Book
Now, I’m ready to go through the Power Query book, Master Your Data with Excel and Power BI, and can’t wait to learn new things!
This is the second edition of their popular book, M is for Data Monkey. I’ve got an autographed copy of that edition on my bookshelf.
You can choose between the digital version of the new edition, or a printed copy. Or, get both!
Get the digital version of the new edition right now, on Ken and Miguel’s website:
________________
Related Links
Power Pivot from Identical Files
________________
Thanks for this Deb, and I’m glad you got your Queries & Connections pane back where it’s supposed to be. (I can’t say that I’ve ever moved it from it’s natural location, as I’ve always been happy with it there – that would have driven me insane!)
My pleasure, Ken, and congrats on getting the book done!
I don’t remember moving that Q & C pane, so it must have been the Excel gremlins 😉
I had a similar problem many times moving a second Excel from one monitor to another. Turned out a different program (a report writer) was somehow interfering. The solution was to run the “repair” option from the Settings/Apps option. Once fixed, it worked fine until either MS did an update or the RW did. Then they didn’t play well together and the “repair” needed to be rerun. Maybe this will work for you.