If you changed your formulae to use the INDIRECT function, you could store the path in a single cell, then change just that cell as/when needed. No macros required. Other than that, a simple Find/Replace should suffice. Again, no macros required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]