Forum Discussion
whyyyyler
Aug 16, 2022Copper Contributor
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...
- Aug 16, 2022Do 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)
MarvelFan_2022
Aug 19, 2022Copper Contributor
Have you tried LinkFixer Advanced? http://www.linktek.com
Our company is looking at trying this for broken links.
whyyyyler
Aug 21, 2022Copper Contributor
I will look into this thank you for suggesting it.
More trying to have the data stored within excel and being able to avoid the issue altogether.
We may have to be an investment in a museum-grade database system.
More trying to have the data stored within excel and being able to avoid the issue altogether.
We may have to be an investment in a museum-grade database system.