Excel Queries & Connections Pane Stuck at Top of Screen

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.

queriesconnectionspane02

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)

queriesconnectionspane01

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.

queriesconnectionspane03

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!

queriesconnectionspane04

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 Query Combine Tables

Power BI Resources

Power Pivot from Identical Files

________________

3 thoughts on “Excel Queries & Connections Pane Stuck at Top of Screen”

  1. 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!)

  2. 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.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.