How can i quickly change about 150 absolute hyper links to pdf files to relative hyperlink's?
Thought I was so smart to insert links to 150 pdf's in an Excel sheet. And thought I'd be nice and tidy by first placing the pdf's in a separate folder. Both folders on same drive (actually on OneDrive)
Now I want to move both the folders to a different OneDrive folder without breaking the links.
Will test tomorrow but I'm pretty sure this will break the links.
Since i don't know how to write vba script, anyone know of a dummy's way to convert these absolute hyper links to relative hyperlinks other than editing each one? Maybe a way to search and replace?
Next time, isn't there something i should change in FIle, properties about the "base"that will automatically force all links to be relative?