Hi, I'm a new user with a link update issue. Is there a quicker way of updating links between multiple worksheets without having to open each and every one of the source files? The files I'm working with have links from a previous version of the files (files are updated every quarter) so the new source files has a new date in the name of the files (i.e. sheet032010 becomes sheet062010). I tried the find and replace method, but it would ask for a file name for each replaced cell. This is a huge file linked to many files so i don't think i'll be able to have all the files open to do the find and replace without being prompted to provide a file name each time. Please let me know if there's an easier solution to this.

Thank you for your help.