Quote:
Originally Posted by simogeo
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.
|
Let's just say the macro has been used by thousands of others who have never had occasion to complain about the format changing.
Quote:
|
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.
|
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.
Quote:
|
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 ?
|
I think you've answered that for yourself...