....both files have to be open for a link from one spreadsheet to another to
work.

"Hyperlink from Excel Cell to Folder" wrote:

i have tried to hyperlink from a cell in an Excel spreadsheet to a folder in
a different directory. It works until I save and close the spreadsheet.
When I reopen the speadsheet the link comes up as invalid. Help.