I have a Summary spreadsheet that gets data from references to many other
workbooks that reside in an organized set of folders. I use hyperlinks to
navigate among the workbooks. The Summary workbook and all the linked
workbooks in the folder set are ALL in one "master" folder. If all the
references and hyperlinks are within that one "master" folder, what changes
would I need to make to keep everything connected if I change the location of
the "master" folder?
Thanks for your help.