Hi Souny,
If the Word and Excel files are kept in the same folder, you can use a macro to update the path to point to whatever the current
folder is. To see how, check out the solution I've posted at:
http://www.wopr.com/index.php?showtopic=670027
--
Cheers
macropod
[Microsoft MVP - Word]
"Souny" wrote in message ...
HI macropod,
Thanks for the information. Is there a way of doing not to break the link?
Is there a way to make the link reassign the path?
Thanks.
"macropod" wrote:
Hi Souny,
The link will invariably break if the absolute path to the Excel file changes (eg you rename a folder in the filepath or you move
the Excel file to a different folder).
--
Cheers
macropod
[Microsoft MVP - Word]
"Souny" wrote in message ...
Hello all,
I have a Word file with embedded objects from Excel. Somehow, the link of
the embedded objects gets broken from time to time. When that happens, I
have to relink them.
Is there a way to make the link not to be broken?
Thanks.