Copying worksheets in Excel and having hyperlinks from master worksheet refer to new (copied) worksheet.

Tinkitten73

New Member
Joined
Nov 5, 2020
Messages
2
Platform
  1. Windows
"I have put together a master sheet I would like to duplicate multiple times. The master sheet has multiple hyperlinks that refer to cells within the master sheet. (Example: When you click on N 1571 it will go to B 10.) When I copy the sheet the hyperlinks links within the new sheet refer back to the master sheet. How can I get the Hyperlink to reference the new sheet cells with out having to reconfigure every link? I have tried to name the cell and then changed the hyperlink to jump to the named range but I get the same results when I copy to a new sheet it refers back to the named cell on the master."

This question was posted before, but I could not find the answer. Any help would be greatly appreciated.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
Hi Tinkitten73, welcome to Mr Excel!

I have tried to name the cell and then changed the hyperlink to jump to the named range but I get the same results when I copy to a new sheet it refers back to the named cell on the master.
It should work if you have created the named ranges with workbook scope. The moment that worksheet is copied, the named ranges on the new worksheet get automatically worksheet scope and are limited to that new worksheet. Your hyperlinks to such named ranges on the same worksheet are therefore also limited to that worksheet.
 

Tinkitten73

New Member
Joined
Nov 5, 2020
Messages
2
Platform
  1. Windows
Hi Tinkitten73, welcome to Mr Excel!


It should work if you have created the named ranges with workbook scope. The moment that worksheet is copied, the named ranges on the new worksheet get automatically worksheet scope and are limited to that new worksheet. Your hyperlinks to such named ranges on the same worksheet are therefore also limited to that worksheet.
Thanks!

How do I "created the named ranges with workbook scope"?
 

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
1,295
Office Version
  1. 2013
Platform
  1. Windows
Actually it's on default, unless you're overriding it using the Name Manager on Formulas tab on the Ribbon ...

On default using the name box:

ScreenShot001.png


ScreenShot002.png



Override using Name Manager:

ScreenShot003.png


ScreenShot004.png
 

Watch MrExcel Video

Forum statistics

Threads
1,126,980
Messages
5,621,946
Members
415,869
Latest member
LWSkinner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top