VBA update multiple copies that are in the "wild" from single parent that is located on sharepoint

[davidred206]

I have an excel workbook that has multiple sheets and formulas that I keep updated on a regular basis. This file is located on the central sharepoint.

I want to send copies that can be updated via vba/macro to become an exact copy of the parent with out having to redownload.

I have looked but am unable to find a single solution.

 

[davidred206]

Anyone have any suggestions?

 

[severynm]

Hi. What you should probably do is use Power Query to add a query into all of the workbooks that pull the data from your master. The data can be refreshed from Data -> Refresh All (or it can be bound to a command button) whenever required by users.