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.