saving hyperlinks between Workbooks

bwlytkr

Board Regular
Joined
Jun 8, 2012
Messages
102
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!!
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

RasGhul

Well-known Member
Joined
Jul 15, 2016
Messages
609
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,950
Messages
5,525,827
Members
409,665
Latest member
Jessyi

This Week's Hot Topics

Top