Hi All,

I have hyperlinks in a sheet and I have used the Hyperlink Function
(=HYPERLINK("[forecast-template-final.xls]b248","Enter COST")).

The problem I am facing is users change the file name. Is there any
way to make this hyperlink dynamic so that the appropriate file name
is captured.

Any suggestions.??

I thought of having a cell where I can pull the file name and have the
hyperlink refer to this cell. Will this work? What is the most
effective way of addressing this problem.

Thanks for your time
Vishnu