external links problem

  • Thread starter Thread starter madmax
  • Start date Start date
M

madmax

This is really starting to piss 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.

I checked the "Ask to Update Links" option (also with other systems)
but this is no good eighter....

(as for some additional info: i use office XP with service pack 2)

Can someone PLEASE tell me how to deal with this? It’s driving me to
desperate insanity…
:mad:
 
There is a setting that each user can set that affects their installation.

If they change it, it doesn't follow the workbook--it stays on that pc.

Tools|Options|Edit
Ask to update automatic links

If you have that checked, then each time you open a workbook (any workbook) with
links, you'll be prompted to find out what you want to do that time.

If you don't have it checked, then the links are updated--but with no prompts.

So maybe your option is different from the other person's.

And since you have xl2002 (do the others?), you can have more control:
Edit|Links|Startup Prompt button

You'll see some options that will travel with the workbook if the users are at
xl2002 or higher.

I'd look at these first.
 
Back
Top