Update links
 

Hi there,

I have a VBA code which consolidates information from 50+ excel files in a
distinct worksheet (without opening the source workbooks), keeping the links
to the sources. Currently, these files are not password protected, but should
be in the future. In this case, I assume I'll have issues when I'll try to
update the information. The easiest solution seems to be to define an unique
password for all files, but in this case all users will be able to open all
files and this is what I'd like to avoid.

Is there a better solution for this?

Many thanks,

Bogdan