I have several workbooks which are source links to a master sheet. I rename
these workbooks each week after I am finished with the week's data. (I "save
as")My problem is that my links automatically change to link to the newly
named workbook. I do not want this. I want the original workbook to always
remain the source of the links. Can someone help me with this problem.

Also, while I am asking ... why do these links #REF! sometimes when I try to
update? How can I prevent that from happening? SImilarly, I sometimes get a
#VALUE! error when I want to open up my master sheet, but not update the
links? How can I prevent this as well?