Disable link prompt from showing up

[n00blar]

Hello,

I have a problem when Excel prompts the user to "Continue" or "Edit Links".
Is there a way to disable this prompt?

Here's what I've tried:
1. TOOLS - OPTIONS - EDIT - unchecked ASK TO UPDATE LINKS (Doesn't work, I
still get prompted to "continue" or "edit links" when I open a spreadsheet
with links.

2. I've used Personal.xls with the following macros:
' Begin Code to close Excel without save dialog
Sub Autpen()
For Each wb In Workbooks
wb.Saved = True
Next

For Each wb In Workbooks
wb.Saved = True
Next
' End Code to close Excel without save dialog

'turn off warnings
Application.DisplayAlerts = False
Application.AskToUpdateLinks = False
End Sub

' Begin Code to close Excel without save dialog
Sub Workbook_Open()
For Each wb In Workbooks
wb.Saved = True
Next

For Each wb In Workbooks
wb.Saved = True
Next
' End Code to close Excel without save dialog

'turn off warnings

Application.DisplayAlerts = False
Application.AskToUpdateLinks = False

End Sub


None of this code seems to do it either.

Anyone knows how to effectively disable these link prompts from showing up?

Thanks.

 

[Gavona]

In Excel 2003 Edit,Links,StartupPrompt
however I do not know how this effects things if opened by an earlier Excel version.

http://www.tek-tips.com/threadminder.cfm?pid=707

is the place for VBA queries if you want a code solution suggest you post there.





Gavin

 

[n00blar]

Thanks for your suggestion, but that only works on a single worksheet; I need this as a global setting, that's why I tried to write code to disable this setting completely.

Thanks.

 

[Gavona]

My suggestion does indeed only work on a single workbook].
Do you want the links updated with no prompt or not updated and no prompt?
A bit perplexed by

"Continue" or "Edit Links".

I get buttons to "update" "don't update" "help"
Is the message when you open the workbook or what?


Gavin