After copying a large worksheet to a new workbook and deleting unneeded columns all hyper links disappeared. Is there anyway to restore them without individually linking each cell in the workbook to the external pdf files that were linked in the original worksheet?
You have probably deleted cells that were used in the HL. Now way to get those back if the file has already been saved. Can you go back to the original and try again?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Weirdly the hyperlink just all started working. I don't what happened. Are hyperlinked external files keyed to an absolute cell reference or to a relative cell reference. Since mine reestablished themselves after I deleted a bunch of columns I'd guess the answer is relative cell references?
Depends how they were put in
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks