Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: how to stop auto show query table at refreshing

  1. #1
    Board Regular
    Join Date
    Sep 2019
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default how to stop auto show query table at refreshing

    hi
    I'm trying to get a few columns hidden with my worksheet using Power Query.

    I've tried hiding the columns like you would do normally in Excel, but every time I refresh the query the columns automatically unhide.
    What can I do to prevent the Columns from unhiding.


    Thanks

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,844
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    remove these columns from Query Table
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  3. #3
    Board Regular
    Join Date
    Sep 2019
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    Quote Originally Posted by sandy666 View Post
    remove these columns from Query Table
    i want automaticaly update this table
    i cant remove from query table

  4. #4
    Board Regular
    Join Date
    Sep 2019
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    Can't anyone help?

  5. #5
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,844
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: how to stop auto show query table at refreshing

    what is you excel version?

    edit:
    post representative example of source data and expected result - share excel file on Onedrive, GoogleDrive or any similar then post link here
    Last edited by sandy666; Sep 12th, 2019 at 03:26 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  6. #6
    Board Regular
    Join Date
    Sep 2019
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    Hello
    I'm using Excel 2016.
    I use the following code for refreshall:


    Private Sub Worksheet_Change (ByVal Target As Range)
    Application.EnableEvents = False
    ThisWorkbook.RefreshAll
    Application.EnableEvents = True
    End Sub


    After each table change, the refreshall command is executed and the query table is displayed.
    I want the query table to never be seen.

    https://doc-14-6o-docs.googleusercon...dsaph17t243bpb

  7. #7
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,844
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    I said SHARE file and post a link to SHARED file

    Access to doc-14-6o-docs.googleusercontent.com was denied

    btw. do you want hide Query Table or hide columns in Query Table?

    if hide Query Table
    - Close&Load to...
    - Connection only
    Last edited by sandy666; Sep 12th, 2019 at 04:32 AM.
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  8. #8
    Board Regular
    Join Date
    Sep 2019
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    http://uupload.ir/filelink/AwJgJ4mYw..._worksheet.zip

    i have one pivot table on query table, so i cant remove or close query table.
    I just want to not display the query table during refreshall

  9. #9
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,844
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  10. #10
    Board Regular
    Join Date
    Sep 2019
    Posts
    57
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: how to stop auto show query table at refreshing

    Please tell me how you did it?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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