+ Reply to Thread
Results 1 to 5 of 5

Loading Power Query Table Multiple Times

  1. #1
    Registered User
    Join Date
    07-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    36

    Loading Power Query Table Multiple Times

    Hi. Is there any easy way to load a table from the same query in multiple different sheets? (without just duplicating the query).

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: Loading Power Query Table Multiple Times

    Why not just duplicate the worksheets?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    36

    Re: Loading Power Query Table Multiple Times

    Oh, well that's certainly an option, but then it duplicates the query as well + I have already made the worksheets where I want to use table. Currently I am pointing to one main table using dynamic arrays on each worksheet, but I realised that having a table on each page would work better for keeping things fully dynamic for my purposes (I could do it with dynamic arrays, but it's going to be more complicated for some of the things I am doing). Worst case scenario, I will just duplicate the queries if need be (just had hope there would be some way to use the same query multiple times without duplication.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: Loading Power Query Table Multiple Times

    Not that I can think of ...

  5. #5
    Registered User
    Join Date
    07-29-2020
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    36

    Re: Loading Power Query Table Multiple Times

    Ah ok. Well in that case, I guess I will be duplicating the queries. Thanks regardless.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Query wrong data loading
    By muad in forum Excel General
    Replies: 3
    Last Post: 02-13-2019, 03:54 AM
  2. Power Query - number not loading
    By Travman1986 in forum Excel General
    Replies: 1
    Last Post: 01-13-2019, 04:35 PM
  3. Power Query and Power Pivot Table
    By haitham.shop in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-06-2018, 06:17 AM
  4. POWER Query and Power Pivot Table !!
    By haitham.shop in forum Access Tables & Databases
    Replies: 0
    Last Post: 08-06-2018, 05:59 AM
  5. [SOLVED] Power Query loading sheets inconsistently
    By armlegx in forum Excel General
    Replies: 9
    Last Post: 05-08-2018, 01:24 PM
  6. [SOLVED] Power Query Not loading all Rows from Source File
    By jdriscol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2017, 04:03 PM
  7. Replies: 7
    Last Post: 07-25-2017, 08:38 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1