external links....HELP!!!!!

[merlin_the_magician]

This is really starting to **** me off…..

I have a workbook that contains several links to external files. All works just fine, except for the popup that appears on opening the workbook asking me wheather or not to update links. YES I want to update the links, and NO I do not want this popup to bother me eith this question every time.
Strangest thing of all…. When I open the workbook on my own pc, there is no popup, but when someone else opens it, the bloody thing appears again and again…. Aaaaargggghhhhh….!!!!

I already tried to disable the “auto update links” option in Edit the menu, but this seems not to be succesfull, the popup still appears.
Also I tried to bypass it by VBA using both

application.asktoupdatelinks=false
as well as

Application.ThisWorkbook.UpdateLinks = xlUpdateLinksNever

Still the thing pops up. It doesn’t seem to matter if the file is stored locally or on a network drive.

Can someone PLEASE tell me how to deal with this? It’s driving me to desperate insanity…

 

[TommyGun]

Well, the VBA solution won't work because the code does not fire until after XL has already prompted the user, so scratch that option.

Now is the "Ask to Update Links" option enabled/disabled on your PC? What about on the other user's PC's?

 

[merlin_the_magician]

VBA works like somes filter after actually opeing the workbook... figured that allright...

The "auto update links" is disabled on the other systems as well, so that is not likely to be the problem...

 

[TommyGun]

I don't know if this is a version issue, but on the Edit tab under Options, check the "Ask to Update Links" option.

 

[merlin_the_magician]

We use Office XP with service pack2.
Checked the "Ask to Update Links" option (also with other systems) but this is no good eighter....

 

[merlin_the_magician]

bump to top...

 

[merlin_the_magician]

bump...bump...bumping....

come on people, there must be some way to deal with this?