Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: how to stop auto show query table at refreshing

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

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

    as I said before
    - Close&Load to...
    - Connection only
    then
    - Insert
    - Pivot Table
    - Use an external data source
    - Choose connection
    - select your Query Table
    - Open
    - select destination place
    - OK
    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!

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

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

    thank you very match

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

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

    you are welcome

    next time post your question about PowerQuery in a proper forum

    have a nice day
    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!

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

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

    Hello
    Is there any other way than power query to combine multiple columns of a table and get a report in pivottable?...

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

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

    the question is too general

    what does that mean: combine multiple columns?
    what you want to achieve before PivotTable?
    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. #16
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,862
    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!

  7. #17
    Board Regular
    Join Date
    Sep 2019
    Posts
    58
    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
    the question is too general

    what does that mean: combine multiple columns?
    what you want to achieve before PivotTable?
    I have some columns of names in the data table and I want to combine them into one column and report by pivottable and make one slicer of the names.

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

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

    see post#16

    but I can't help with vba or formula
    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!

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
  •