I think the problem is the same as a problem i had. Excel tries to "UPDATE" the links when you save a file and "corrupts" the link. To fix this you can turn auto link updating off. DATA>OPTIONS>GENERAL click on web options button. Under the tab named FILES deselect "update links on save". This worked well for me but I wish microsoft would fix the problem.
PL
"JR" wrote:
[Quoted Text] > ...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.
|