Hyperlinks in Excel database don't work when file is reopened.
 

I have set up a database in Excel 2002 with hyperlinks to photo files in My
Documents. This has worked in the past. However, now, although it works
when I set it up, and as long as the file remains open, when I close the
database and then reopen it, the hyperlinks don't work. Please can you
advise what I might be doing wrong?