Update links when duplicating a sheet

C

chippy36

New Member
Joined
Dec 24, 2017
Messages
21
Hi all,

I have a sheet where cell, K3 links to A3. When I duplicate the sheet, on the new sheet K3 links back to A3 on the original sheet.

How can I duplicate the sheet but the new K3 links to its own A3 and not to the original sheet?

I know I can manually update the link but I make hundreds of duplicate sheets so that's not really an option

Thanks in advance
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sort by date Sort by votes
How do you duplicate the sheet that cause it to link to the original sheet?
 
Upvote 0
chippy36 said:
Right click on the tab, make a copy
Click to expand...
I tried but my simple formula on new copied sheet still link to the copied sheet. Maybe you can create sample that give problem?
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Question
VBA Loop Through Data Validation Drop Down List
Replies
5
Views
356
rlv01
R
D
  • Question
Results by handicap - with ties. Look up by score without duplicates
Replies
4
Views
85
dkjonesau
D
A
  • Question
Excel Online Sharepoint - Workbook Links Updating with New Rows Added
Replies
0
Views
95
ah_mktanlys_01
A
N
  • Question
VBA Macro Issue - VBA to automate creating new PP/Excel sheets and updating the links
Replies
0
Views
453
noobslayer252
N
W
  • Question
Sheet that updates by referencing cells in workbooks located in separate folders on shared drive
Replies
0
Views
150
Woodpusher147
W

Forum statistics

Threads
1,214,915
Messages
6,122,214
Members
449,074
Latest member
cancansova

Share this page

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
Back
Top