Forum Discussion
Solved
Possible portable image links.
Good morning. I would greatly be appreciative of anyone who would have a potential answer to my problem. I’m in the process of making a huge database and need to have access to photos. We are...
- Do the files move without you knowing it? Or do you just need a quick way to update the hyperlinks when (for example) the drive letter or a folder name changes? In any case, try using the HYPERLINK function with the path and name of the file as text in an adjacent cell:
=HYPERLINK("file:"&A2)
Do the files move without you knowing it? Or do you just need a quick way to update the hyperlinks when (for example) the drive letter or a folder name changes? In any case, try using the HYPERLINK function with the path and name of the file as text in an adjacent cell:
=HYPERLINK("file:"&A2)
=HYPERLINK("file:"&A2)
JKPieterse Thanks for your reply. I am trying to avoid a separation of data.
Where I could have the database on an excel file, click the link in the cell and get directed to the image of the document within excel, then being able to send the same excel file and e.g. put on a USB or email to someone else and they will have the same data.
Trying to avoid having it link to an online site and then one day; the link breaks, lost forever, and useless to the viewer, as well as having the link open a file on my computer, but then once on another device, not working as the shortcut was to a folder on my computer that they do not have.
Microsoft Access does a similar job however is a PC-only program, looking for versatility.
Thanks!
