Thread: Linking Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default Linking Problem


there's also an UpdateLinks property..
make sure its set to: 3/xlupdateLinksAlways

else the links aint updated when you open the file
containing the links.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


?B?Sm9obiBN?= <John wrote:

I just encountered a strange problem. I have "file #1" which is
linked to "file #2". I copied "file #1" and called it "copy file #1"
so I could compare it to my new version of "file #1". "File #2" was
updated and linked into "file#1". When I opened "file #1" and "copy
file #1", my updated "file #1" links reverted back to the old link
values that were in "copy file #1". I have to open "file #2" again in
order to get the proper values in my updated "file #1".

Does anyone know how I can prevent this from happening. I already
have checked the "save external link values" option. Thanks.