Stop Update Links pop up when opening a excel 2013 file vba

[bleeet]

Hi guys

I just ran into a problem where my excel file runs OK in excel 2010 but when someone opens it in excel 2013 they get a menu pop up warning about it being unable to update a link. I have been trying stop this but no luck

I have tried the code below in workbookopen() but still no luck. Does anyone happen have some idea on what I can do to stop this?

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; white-space: inherit;">Application.AskToUpdateLinks = False
Application.DisplayAlerts = False
</code>

 

[Vinoth_Shob]

Somewhere in your macro you're opening the workbook.

To turn off the update links prompt you have to specify in the Open method whether or not to update the links.

Sub Macro1()
MyFile = "C:\Documents and Settings\Desktop\Mult_Table.xls"
Workbooks.Open Filename:=MyFile, UpdateLinks:=True
End Sub

 

[Vinoth_Shob]

else try this

go to Edit>links - Start up Prompts and Tools>Options-Edit - Ask to update automatic links