I have an excel databse containing hyperlinks to certain pdf files. The folder containing the pdfs and the excel database file are located in the same folder. I needed to make certain changes in the database for which I created a copy of the original excel file and made all the changes. Now I want to delete the original file and keep the new file. But I noticed that none of the hyperlinks are working in the new file. I haven't changed the location of the folder containing pdfs and the location of the new excel sheet is exactly same as the original one. To make them work again I will have to edit each hyperlink and provide the address again. But the sheet is too large. I am looking for a way in which the hyperlinks can be updated automatically. Kindly help. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Update/refresh hyperlinks to other files.
- Thread starter ashish514
- Start date
Jaafar Tribak
Well-known Member
- Joined
- Dec 5, 2002
- Messages
- 9,779
- Office Version
- 2016
- Platform
- Windows
How about copying the worksheet containg the hyperlinks onto the new workbook ?
Upvote
0
Similar threads
- Question
