I have seen sometimes where the links will automatically update
themselves...at other times it does not work....what is the difference.

i.e. I have a Folder Named "AA" that has 3 excel workbooks in it (A, B, C).
If I rename A to F, sometimes it works and sometimes it doesn't. Why?