 KilroyPremium,MVM join:2002-11-21 Ann Arbor, MI | reply to Danny_P
Re: [Excel] Excel links break when moved Sounds like you need them to be absolute links. You can do it for cells by pressing F4, it changes from A2 to $A$2, this indicates that it will always use A2, so if you copy from A3 to B3 it will still use A2.
Don't know how to do this for a file location, but would assume there is a way. Just trying to point you in the right direction. -- Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something. ¯ Robert A. Heinlein |