[Souny]

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.

[macropod[_2_]]

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.

[Souny]

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.

[macropod[_2_]]

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.