Linking Excel into WORD doc

[anthony]

I have a homemeade application linking a spreadsheet (Excel
2000) to a WORD document. It is quite a cumbersome
application but works well except for a few strange
glitches.

Glitch #1. Periodically, the source for one of my links
will change. My source document should be c:/close.xls.
sometimes on of the links wil change to a:/close.xls. Ther
is no consistent pattern to which one that changes. And it
doesn't change every time I use the application. I only
know because the a: drive will begin whirring. I then go
in, find the link, change the source, and re-save the
document. A week or so later, the whirring noise again and
a coupletely different link will have changed sources.

Glitch #2. Some of my links are inside tables. Does that
present any special challenges? I ask because I have a few
that won't update unless I update them manually. All of
these happen to be inside tables. I have other links that
perform normally in some of the same tables, so I may be
grabbing at straws and the whole tables connection may be
coincidence.

I can only imagine that this is difficult to convey without
you seeing the actual docs.

Thank for any guidance you can provide.

 

[Cindy M -WordMVP-]

Hi Anthony,

I have a homemeade application linking a spreadsheet (Excel
2000) to a WORD document. It is quite a cumbersome
application but works well except for a few strange
glitches.

Glitch #1. Periodically, the source for one of my links
will change. My source document should be c:/close.xls.
sometimes on of the links wil change to a:/close.xls.

If this were Word 2002 or 2003, then I'd say check the
setting under Tools/Options/General/Web options/Files for
updating links on save. This is broken in Word 2002, and
activates when saving regular documents, not just HTML files.
But as far as I know, it works properly in Word 2000. In any
case, it's the ONLY thing I know of that can change the link
in a field.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[anthony]

-----Original Message-----
Hi Anthony,

If this were Word 2002 or 2003, then I'd say check the
setting under Tools/Options/General/Web options/Files for
updating links on save. This is broken in Word 2002, and
activates when saving regular documents, not just HTML files.
But as far as I know, it works properly in Word 2000. In any
case, it's the ONLY thing I know of that can change the link
in a field.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

.

Thanks for your reply Cindy and sorry I was unclear. The
link doesn't change. The "source file" changes. When I
look at Edit>Links}, the source file's drive letter has
changed to the a:/ drive. I change the source back to c:/,
and save the document. But when it I open it again, the
links have reverted back to the a:/ drive. My OS is
Windows 2000 if that matters.

I was also mistaken earlier; this is happening to just two
of the 147 links in the application. Unfortunately, I
cannot decipher which two, the dialog box shows "item"
names as !R171C4 and !R17C4 which relates to nothing in my
naming system. My links all have names like D3 or D115.

As I said, I have 147 links in this document and only a few
are causing me all this headache. Thx.

 

[Cindy M -WordMVP-]

Hi Anthony,

I was also mistaken earlier; this is happening to just two
of the 147 links in the application. Unfortunately, I
cannot decipher which two, the dialog box shows "item"
names as !R171C4 and !R17C4 which relates to nothing in my
naming system. My links all have names like D3 or D115.

OK, then I'd guess the field codes maintaining the links are
damaged. If you press Alt+F9 do you see LINK fields instead
of the Excel objects? Or do you see the objects?

D3 would translate to R3C4 (row 3, column 4). That should
help you localize which links are causing the problem.
You'll need to delete and recreate them.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail