In a chain of links, how can I automatically remove the middle lin

G

Guest

I have a link that goes through a chain of links to ultimately link to the
source file. Is there a way for me to automatically change the ending link
to point to the source file instead of moving through the chain of links?
 
G

Guest

sure....... have your source file open and your file that you have the link
via other workbooks or sheets.In your destination cell type = and then click
straight on the source cell overwriting the existing link
 
G

Guest

Thanks for your response - do you know if there is a way to do this
automatically? My end file has a large number of links that go through the
middle file to get to the source file. I want to delete the middle file
without having to manually link all the cells in the end file to the source
file. The "edit links" function does not work, as the middle file and source
file house the data in different cells, tabs, etc. I'm not sure this can be
done but it would save me lots of time!
 
G

Guest

so change source under the edit links didnt work?.I have only only ever
changed from one version of a source sheet to another version
 

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