The dialogues will always default to whatever folder the existing link(s) point to. If these documents and their corresponding Excel workbooks are always kept in the same folder, or at least folders with the same parent/child names, you may find it useful to implement relative paths via the
macro solution I've posted at:
http://windowssecrets.com/forums/sho...External-Files