I'm creating a spreadsheet of information regarding pdfs on the computer. Each file has its own row on the spreadsheet.
I know I can add hyperlinks to the spreadsheet so I can easily open the relevant file if needed. Can I save a copy on an external hard-drive which will include the 'working' hyperlinks? I would be saving the files on the hard-drive as well, but I'm not totally convinced everything would still work smoothly as the source of the files will change. Is there a way to make this happen?