Silverscreen
New Member
- Joined
- May 9, 2014
- Messages
- 22
Hi all,
I currently have a file which links into 3 other large files (in order to consolidate the data) but the issue is that they are all password protected so in order to relink to the next month's version, I end up have to open quite a few files just to do this and sometimes it breaks excel.
does anyone know of any macro that would allow me to update the links in a quicker manner?
I currently have a file which links into 3 other large files (in order to consolidate the data) but the issue is that they are all password protected so in order to relink to the next month's version, I end up have to open quite a few files just to do this and sometimes it breaks excel.
does anyone know of any macro that would allow me to update the links in a quicker manner?
