Hi Anthony,
> I have a homemeade application linking a spreadsheet (Excel
> 2000) to a WORD document. It is quite a cumbersome
[quoted text clipped - 4 lines]
> 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 - 08 Jan 2004 00:23 GMT
>-----Original Message-----
>Hi Anthony,
[quoted text clipped - 26 lines]
>
>.
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- - 08 Jan 2004 09:54 GMT
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
:-)