Anyway to automatically update from a shared workbook?

[wageslave101]

Hi I'm new here so I apologise if this a newbie question

I would like a workbook to automatically update from another book at the moment I've a button in a sheet that when selected does

Sub TLRefresh()
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Windows("TeamData.xls").Activate
    ActiveWindow.Close
    Workbooks.Open Filename:="TeamData.xls"
    Windows("TLRecord.xls").Activate
    ActiveWindow.WindowState = xlMaximized
    Application.DisplayAlerts = True
    Application.ScreenUpdating = True
End Sub

The problem I'm encountering is that the TeamData.xls is a Shared Workbook and when I run the macro I get a message box

"This workbook contains links to other data sources..."

At which point it pauses waiting for a user to select Update or Don't Upate.

I would like this to select Update without any user intervention - is this possible?

Sincerely,
WageSlave101

 

[Smitty]

Welcome to the Board!

You can goto Tools-->Options-->Edit-->Uncheck "Ask to update automatic links".

Hope that helps,

Smitty

 

[wageslave101]

Thank you very much mate

I just added in a;

Application.AskToUpdateLinks = False
.
Application.AskToUpdateLinks = True

Around it and that worked a charm.

Thank you very much again for your help

Cheers,
WageSlave101