Thanks macropod.

Actually, I really think the replace script breaks formatting and I explain you why :

• When the path is changed and the document is closed. If I re-open it again, even when changing data from Excel linked file, data are refreshing without changing formatting.
• By the way, I can observe that the \a option disappear when path is changed. I don't know why this option is for but I thought that could be the flag. What do you think ? I am not sure at all about that but I'm curious and may be a clue.

To finish, I've read in others posts/forums what you wrote on relative path, and even try to use {FILENAME \p} with LINK in vain ... can you confirm that there is no way to make LINK work with that workaround ?




Thanks for your reply.

Let's just say the macro has been used by thousands of others who have never had occasion to complain about the format changing.
the \a switch is for automatic updates. Since the macro is doing the updates, that switch becomes inappropriate and is liable to double the number of updates required.
I think you've answered that for yourself...

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

That's clear enough ! This means it should be possible

Indeed. I'll remove it.

I'll investigate again on my part. Thanks for quick and accurate replies.