Excel power query data update

Spookyest 1 Reputation point
2020-08-06T16:39:39.05+00:00

Hi

I’ve tried to search for this but seemed to get nowhere.

What I’m after is a way to have a master workbook that gets updated from various separate user workbooks.

The user workbooks would refresh with the current data but can be updated and pushed to the master workbook.

Hope this makes sense

So is it possible to have a power query setup that’s like this 

        <——> user

Master <——> user
<——> user

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.4K Reputation points MVP
    2020-08-06T19:52:37.41+00:00

    They're actively answering Power Query questions in dedicated forums here.
    https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery

    --please don't forget to Accept as answer if the reply is helpful--

    0 comments
  2. Emily Hua-MSFT 27,581 Reputation points
    2020-08-07T06:53:07.007+00:00

    Hi Spookyest,

    Are the video "Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks" and article "How To Import Multiple Files With Multiple Sheets In Power Query" helpful? After loading data to a table, you may set the refresh data when opening the file or refresh time.

    (Please Note: Since the web sites are not hosted by Microsoft, the links may change without notice. Microsoft does not guarantee the accuracy of this information.)

    As we are mainly responsible for general issues of Office desktop applications, more in-depth questions on how to use Power Query, it's best ask a new question into Power Query forums. Thanks for your understanding.

    0 comments