Broken Links


J

JayBee

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
 
Ad

Advertisements

B

Barb Reinhardt

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.
 
Ad

Advertisements

J

JayBee

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top