Change links only in selected cells

D

Deuce Bucksman

Board Regular
Joined
Jan 17, 2011
Messages
102
Hi gurus-

Is it possible to change links in a spreadsheet but only for certain cells? For example, I am linking a spreadsheet in one column that is the exact same spreadsheet in another folder, under a different name. Is there a way to change the link for each column so I don't have to manually update the cells with each model? Or does the change links function change all links in the document?

Really appreciate your help!
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

K
  • Question
Extract links from Excel document and create .M3u8 files for each url link found in the sheet.
Replies
1
Views
51
KOKOSEK
KOKOSEK
J
  • Question
Not sure if Excel can do this...
Replies
1
Views
132
Sam_D_Ben
S
F
  • Solved
Copy data and charts to another Workbook w/o retaining Link to Original File
Replies
5
Views
71
Giordano Bruno
G
R
  • Question
Excel Chart Series Do Not Retain Links to Dynamic Named Ranges And Reset Back to Static Ranges
Replies
2
Views
549
rkaczano
R
B
  • Question
Strange behaviour of cells that are set with links
Replies
1
Views
168
bulletcss
B

Forum statistics

Threads
1,195,950
Messages
6,012,487
Members
441,701
Latest member
vnkendijs

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
Top