Embedded Excel Object in Word Not Working

Hi,
I have embedded an Excel object into my Word document (both 2003) and
I would like to link a cell from this object into the document itself
as part of a narrative. I can get it to work by opening up the object
and copying the cell I want to link. I then do a paste special - paste
link - and select formatted text (RTF). When I go back and change some
of the values in the Excel object the cell in question changes in the
Excel object as well as in the narrative so it is working. The issue
is when I close and reopen the document. I get this error.

"Objects in this document contain links to files that cannot be found.
The linked information will not be updated."

I figured by embedding the Excel object into Word, all the links would
be self contained in the document. That way I can send this file out
and not worry about external links. Is this a correct assumption?
What is the best way to go about fixing this issue?

Thank you in advance for your time.

Hi,

Although what you're doing is sound in theory, it doesn't work in practice. The only practical way around it is to have an external
Excel worksheet and link to that in both cases.

As for being able to move the document and Excel file around, you need to force Word to use relative paths. To do that, check out
the solution I've posted at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=670027
You'll need to use the macro attached to that post.

--
Cheers
macropod
[MVP - Microsoft Word]


<carlsondaniel.DeleteThis@gmail.com> wrote in message news:b132677b-f0a4-4536-b775-ba2725e820f6@s9g2000prm.googlegroups.com...
> Hi,
> I have embedded an Excel object into my Word document (both 2003) and
> I would like to link a cell from this object into the document itself
> as part of a narrative. I can get it to work by opening up the object
> and copying the cell I want to link. I then do a paste special - paste
> link - and select formatted text (RTF). When I go back and change some
> of the values in the Excel object the cell in question changes in the
> Excel object as well as in the narrative so it is working. The issue
> is when I close and reopen the document. I get this error.
>
> "Objects in this document contain links to files that cannot be found.
> The linked information will not be updated."
>
> I figured by embedding the Excel object into Word, all the links would
> be self contained in the document. That way I can send this file out
> and not worry about external links. Is this a correct assumption?
> What is the best way to go about fixing this issue?
>
> Thank you in advance for your time.
>
>
>