newparadigmz
asked on
Can't get rid of Update Links message in Excel 2013
ASKER
Thanks, but my original posting shows that I have done this.
Hi newparadigmz,
In the Startup Prompt select the third option "Don't display the alert and update links".
"In your posting you shown the second option selected".
Regards,
D Patel
In the Startup Prompt select the third option "Don't display the alert and update links".
"In your posting you shown the second option selected".
Regards,
D Patel
Try running this code
Option Explicit
Sub BreakLink()
Dim aLinks As Variant
Dim Ctr As Long
aLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)
If IsArray(aLinks) Then
For Ctr = LBound(aLinks) To UBound(aLinks)
ActiveWorkbook.BreakLink Name:=aLinks(Ctr), _
Type:=xlLinkTypeExcelLinks
Next Ctr
End If
End Sub
ASKER
@DPatel, That did not work
@Roy_Cox, but I need the link to exist. I just don't want the message showing up every time I open the sheet.
@Roy_Cox, but I need the link to exist. I just don't want the message showing up every time I open the sheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks, turns out an external program was over-riding this.
Pleased to help
1. Please go to click File > Options (In Excel 2007, click Office button > Excel Options), in the Excel Options dialog box, click Advanced in the left pane, and then uncheck Ask to update automatic links under General section
2. Then click OK to close this dialog, when you open this workbook next time, the links are automatically updated, and additionally, no message appears.