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