Update of All Workbooks in a folder from the main Workbook

[BebeM]

Greetings to you All

-I need your help with updating all saved workbooks which are saved on our server and in one folder named Office Files,
-all the workbooks are saved with the same ending of - LDS (e.g. Paul Smith - LDS; Gina Khoza - LDS etc)
-these workbooks are sourced from the main workbook, LDS v.003
-Recently, my colleagues keeps coming to me and request some changes to be implemented on these workbooks and i have to do that 1-by-1
-is there a way that i can just update the main workbook named LDS v.003 and then some magic happens to all other workbooks saved in the Office Files folder? and all of them get updated?
-I sometimes jump some workbooks or forget to update them because it is usually a lot (there are currently 107 workbooks saved in our Office Files Folder)

Your assistance is always appreciated

From Bebe

 

[dmt32]

Without more understanding of your workbooks structure can only give initial thoughts but if the workbooks saved in folder on your corporate network & they are, as you say, sourced from your main workbook, then one possibility *MAYBE* you could consider would, rather than you updating each individual one, have those workbooks refresh their data from the main workbook when user opens it. This would need some code placed in user workbooks to perform the refresh action.

Suggest, if possible, that you provide copy of your main workbook (with dummy data) using MRExcel Addin: XL2BB - Excel Range to BBCode

as well as a copy of user workbooks (with dummy data) or better still, provide copy of each using a file sharing site like Dropbox & provide a link to it here – maybe then, forum will be able to suggest other possible solutions for you.

Dave

 

[BebeM]

Without more understanding of your workbooks structure can only give initial thoughts but if the workbooks saved in folder on your corporate network & they are, as you say, sourced from your main workbook, then one possibility *MAYBE* you could consider would, rather than you updating each individual one, have those workbooks refresh their data from the main workbook when user opens it. This would need some code placed in user workbooks to perform the refresh action.

Suggest, if possible, that you provide copy of your main workbook (with dummy data) using MRExcel Addin: XL2BB - Excel Range to BBCode

as well as a copy of user workbooks (with dummy data) or better still, provide copy of each using a file sharing site like Dropbox & provide a link to it here – maybe then, forum will be able to suggest other possible solutions for you.

Dave

Noted, will do so