Repairing broken links after moving files.

mwhassan

New Member
Joined
Aug 2, 2007
Messages
29
Hello all. Just a general question, I am almost sure this is possible but can't remember. Is there a way for excel to automatically reassign links when a linked file (the file with the original data) is moved from one folder to another? I have several files that have a huge amount of links that I need to put in a public folder at work I always have to reassign the links. Is there a way around this?


THANKS!!!
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Thanks for your quick reply. What I am trying to figure out a way for the links to AUTOMATICALLY (without having to reassign the links) reassign themselves, I am almost 100% sure I have done this before but I can not remember how.
 
Upvote 0
Thanks for your quick reply. What I am trying to figure out a way for the links to AUTOMATICALLY (without having to reassign the links) reassign themselves, I am almost 100% sure I have done this before but I can not remember how.

How could they possibley do that? How could a formula know where you moved the file to?

I think the ONLY way that could happen is If

BOTH files are open (file with the links, and the file linked to).
And in the file linked to you click File - Save As, and change to a new directory.

Then the formulas would auto update to the new location..
 
Upvote 0

Forum statistics

Threads
1,213,585
Messages
6,114,518
Members
448,575
Latest member
hycrow

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