Excel power query data update

Question

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

Answer 1

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--

Answer 2

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.