I have created a series of workbooks and saved them in subfolders of a main
folder. Individual cells on the various sheets in the workbooks have links to
other workbooks within this series.
The problem I have is that when I copy the folder onto another computer then
the links wont work as it is looking for the original file path, which has
changed due to it being located in a diferent place on another computer. I
can rectify this by removing the password protections of each sheet in all
the workbooks and then, under links, changing the link source. Trouble is
this is a huge amount of work.
Anyone got any ideas on how I can overcome this, please?
Many thanks

Why not do a global find and replace? This won't fix links that are
embedded in named ranges or charts. I seem to find more links in charts
than anywhere else. I've not taken the time to figure out how they get
there (I don't create them initially) , so if someone knows, let me know.
--
HTH,
Barb Reinhardt



"JayBee" wrote:

I have created a series of workbooks and saved them in subfolders of a main
folder. Individual cells on the various sheets in the workbooks have links to
other workbooks within this series.
The problem I have is that when I copy the folder onto another computer then
the links wont work as it is looking for the original file path, which has
changed due to it being located in a diferent place on another computer. I
can rectify this by removing the password protections of each sheet in all
the workbooks and then, under links, changing the link source. Trouble is
this is a huge amount of work.
Anyone got any ideas on how I can overcome this, please?
Many thanks

Thanks,
I'll give it a go.
I suppose I'm looking for the equivalent of being able to run it stand-alone
from, say a CD.
Many thanks

"Barb Reinhardt" wrote:

Why not do a global find and replace? This won't fix links that are
embedded in named ranges or charts. I seem to find more links in charts
than anywhere else. I've not taken the time to figure out how they get
there (I don't create them initially) , so if someone knows, let me know.
--
HTH,
Barb Reinhardt



"JayBee" wrote:

I have created a series of workbooks and saved them in subfolders of a main
folder. Individual cells on the various sheets in the workbooks have links to
other workbooks within this series.
The problem I have is that when I copy the folder onto another computer then
the links wont work as it is looking for the original file path, which has
changed due to it being located in a diferent place on another computer. I
can rectify this by removing the password protections of each sheet in all
the workbooks and then, under links, changing the link source. Trouble is
this is a huge amount of work.
Anyone got any ideas on how I can overcome this, please?
Many thanks