I am having problems with losng my hyperlinks when I save the exel spreadsheet to another workbook name. Is there any way to save my hyperlink info to another workbook so it appears in the new workbook. Any help would be greatly appreciated!!
-
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.
saving hyperlinks between Workbooks
RasGhul
Well-known Member
- Joined
- Jul 15, 2016
- Messages
- 797
- Office Version
- 365
- Platform
- Windows
When you use standard hyperlinks it hard codes the current workbook/sheet referencing with it.
You could use hyperlink formula instead so that is dynamically changes with your workbook name. e.g. =HYPERLINK("#Sheet1!"&"$Target Column$"&Target Row,"Link Name")
I just tested a workbook that I have with the above formula, when I saved as a new workbook name the hyperlink still works correctly.
Just the sheet reference & target sections of the formula to suit each cell you are linking to.
You could use hyperlink formula instead so that is dynamically changes with your workbook name. e.g. =HYPERLINK("#Sheet1!"&"$Target Column$"&Target Row,"Link Name")
I just tested a workbook that I have with the above formula, when I saved as a new workbook name the hyperlink still works correctly.
Just the sheet reference & target sections of the formula to suit each cell you are linking to.
Upvote
0
Similar threads
- Question
