I have a database with a problem that I hope someone can help me fix.

The database has many hyperlinks to photos stored on my hard drive.  When I create a new one, the relative addressing works just fine.  Some time ago, the PC crashed and all the addresses had “../../../AppData/AppData/AppData/AppData/AppData/AppData/AppData/AppData/Roaming/Microsoft/Excel/” appended to the front of the relative address (perhaps that string suggests it’s happened 8 times?).  To now use a hyperlink, I have to edit the individual address. Then, when I save the workbook, the relative address is saved, which is good.

However, the database has several thousand of these corrupted links and I don’t want to do them all one by one.  I’ve found the search function does not look within the hyperlink address, and saving the file with a different name has no effect.

Is there a way I can do a bulk delete of that text string?  

​I have a database with a problem that I hope someone can help me fix.The database has many hyperlinks to photos stored on my hard drive.  When I create a new one, the relative addressing works just fine.  Some time ago, the PC crashed and all the addresses had “../../../AppData/AppData/AppData/AppData/AppData/AppData/AppData/AppData/Roaming/Microsoft/Excel/” appended to the front of the relative address (perhaps that string suggests it’s happened 8 times?).  To now use a hyperlink, I have to edit the individual address. Then, when I save the workbook, the relative address is saved, which is good.However, the database has several thousand of these corrupted links and I don’t want to do them all one by one.  I’ve found the search function does not look within the hyperlink address, and saving the file with a different name has no effect. Is there a way I can do a bulk delete of that text string?     Read More

​