Results 1 to 5 of 5

Thread: Queries pane will not go away

  1. #1

    Queries pane will not go away



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a similar problem that just started recently. When I click in the Excel table (created by PQ), the Workbook Queries pane opens and will not go away. Clicking the Show Pane button causes the pane to close and immediately reopen. The Show Pane button remains 'selected'/highlighted/enabled. When I click off the table, both the button and the pane behave properly.
    Microsoft Windows 7 Enterprise. Version 6.1.7601 Service Pack 1 Build 7601. Excel 2013 (15.0.4963.1000) MSO 15.0.4963.1002) 64-bit Office Pro Plus


    Edit Mod : this thread relates to https://www.excelguru.ca/forums/show...7-Hide-Queries
    Last edited by Pecoflyer; 2018-01-13 at 09:31 AM. Reason: Add link and create thread

  2. #2
    Any update on this annoying 'feature'? I'm on Microsoft Excel 2013 (15.0.4989.1000) MSO (15.0.4989.1000) 64-bit, MS Office Professional Plus 2013 on a Windows 7 Enterprise 64-bit system. The Power Query Update tab is grayed out.

  3. #3
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,202
    Articles
    57
    Blog Entries
    14
    Hi Timmybro,

    I'm pretty sure the "by design" behaviour in 2010/2013 was to open the Query Pane every time you selected a table that was created by Power Query. I am surprised that you can't close the Query Pane though... that's odd. As a workaround, can you make the Query Pane narrower so that it doesn't affect your screen space? I know that's not ideal...

    Can you also share what version of Power Query you are using? I believe there should be a Help button on the Power Query tab. That will have a different version number than Excel.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  4. #4
    Ken Thanks, I've been using that workaround. Here's the PQ Version: 2.49.4831.381 64-bit. And btw, I don't think this used to happen until a few months ago, but i could be mistaken.

  5. #5
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,239
    Articles
    0
    @timmybro
    Please don't hijack existing threads. It's better to start a new thread ( which I did for you) eventually with a link to an existing thread. You will get faster answers and your question will be indexed on search engines.
    Cheers
    Thank you Ken for this secure forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •