merlin_the_magician
Active Member
- Joined
- Jul 31, 2002
- Messages
- 480
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…
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…