From here you start the enroll function, which creates all Slaves based on the definitions and Slave template, placing all NamedRanges with the Prefix added (eg. Then a definition of all Slave instances is entered through a userform, Prefix, Path, Name, Password, User, etc. Each named range has to be in table format with headers. This information is pushed to the DataStore. In the Slave template all source areas are defined as named ranges (E.q. Meaning that there is some kind of structure to the data. Note that this method is developed for aggregating data. There is of course the Workbook Connection method, but the real drawback is that if you choose to store the password with the connection string, the password is saved as plain text. There are some SendKeys solutions for this, but if you need to synchronize with many slaves with different passwords (which mostly is the case as it’s a security issue to have a default password for all sheets), this is not a practical solution. When the slaves are protected you have to enter all passwords for each slave to update the data. If cells are linked by address (=Sheet!Range)) there is a change that when rows or columns are inserted or deleted, the reference will point to a wrong area or lose its reference. Master sheets with aggregated data from multiple sheets (especially when protected), can be a real stumbling block. Slave sheet (individual data, is source, all slaves are equal as they resort from the same template))ĭataStore (database where slaves push data to, and from where data is pushed to the master)

Slave Template (template format of the slave Workbook) Master sheet (has the aggregated data, is target) In a glance, the method is based on the next principles and rules: If it is of interest to you, you're welcome to participate in testing a new approach to synchronize data from multiple (protected and unprotected) workbooks into one or more masterbooks. From your first post I didn't get the message right. Hi, actually you triggered me to finally finish developing a procedure to have this problem sorted for once and for all.

How to create a password for excel file