Link to home
Start Free TrialLog in
Avatar of newparadigmz
newparadigmzFlag for United States of America

asked on

Can't get rid of Update Links message in Excel 2013

have tried many things, but this message persists....

User generated image
User generated image
User generated image
Avatar of Anastasia D. Gavanas
Anastasia D. Gavanas
Flag of Greece image

Try through Excel Options

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.
Avatar of newparadigmz

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
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

Open in new window

@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.
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks, turns out an external program was over-riding this.
Pleased to help