I think I'd try creating the hyperlinks using the worksheet function:
=hyperlink().

Say your filename is in A2, then put this in B2:
=hyperlink("file:////"&a2,"Click Me")

and see if it works.

A2 should contain the full path:
c:\my documents\excel\myfile.xls
or
\\sharename\folder\myfile.xls



RolandIllman wrote:

I have a list with about 380 records which I use with filters on at the top
of the column. One column refers to filenames which I have tried to replace
with hyperlinks - I set the links up then after eg filtering, and moving
around the sheet, and perhaps closing & reopening the book, the links fail to
work again, the error message is "address not valid".
How can I ensure the links keep working ? I am working on a network.

--

Dave Peterson