Fixing Broken Links between Workbooks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hunscot@gmail.com - 07 Oct 2007 03:27 GMT

Hello,

Newbie with Link woes....

How do I prevent Excel form replacing my relative link path with an
absolute link path that breaks ALL my List Links shared bewteen 2
workbooks and sheets?

I have succefully set up 2 Workbooks to share Linked Lists and had it
working. IE: =MASTER_KEYWORDS.xls!KEYWORDSEARCH_LIST_1

Now the "refer to" drills down ='HD/DOCS/FOLDER_A/FOLDER_B/
Workbook......etc poof, no list links work.

I believe I am missing some Excel file handling "etiquette" . These
workbooks/worksheets are very picky. What is the best way to prevent
this from happening and can I restore them some easy way?

Thank you,
Scott

Reply to this Message

JE McGimpsey - 08 Oct 2007 15:00 GMT

> I have succefully set up 2 Workbooks to share Linked Lists and had it
> working. IE: =MASTER_KEYWORDS.xls!KEYWORDSEARCH_LIST_1
[quoted text clipped - 5 lines]
> workbooks/worksheets are very picky. What is the best way to prevent
> this from happening and can I restore them some easy way?

I suspect you're not using MacXL, which is the topic of this newsgroup
(hence the .mac. in the name), but it works much the same in both
platforms.

You don't really create a "relative link" - all links are absolute, but
when the source workbook is open, XL only displays the truncated
path/filename.

Use Edit/Link to change the source of the link to the new location of
your source workbook.

Reply to this Message

hunscot@gmail.com - 09 Oct 2007 17:46 GMT

Hi JE,

Thank you for the reply. I will try your suggestion right away.

Thanks again for the help and fix!!!

Best,
Scott

2004 for Mac
Ver. 11.3.3 (061213)

Reply to this Message

Mac Forum / Applications / Excel / October 2007

Fixing Broken Links between Workbooks