Macro To Refreash A Sheet Every 15 Min.

[rockyw]

I have an Excel sheet running on a big screen and would like to refresh the sheet every 1 min or so. The code below I can refresh manually but can I run a second macro or add to this on and refresh and save automatically? Thanks

Sub Update()
'
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

'

'
End Sub

I tried this but I get an error that says its unavailable

[COLOR=#333333][FONT=Tahoma]Sub Update()
'
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
Application.OnTime Now + TimeValue("00:01:00"), "Sub Update()"
'
'
End Sub[/FONT][/COLOR]

.

 

[John_w]

Change the Application.OnTime to:

    Application.OnTime Now + TimeValue("00:01:00"), "Update"

 

[rockyw]

I still get the same error

 

[John_w]

Where have you put the code? It should go in a standard module, not a sheet module.

 

[rockyw]

Tried in both but same error

 

[John_w]

Here is the whole code which works for me:

Sub Update()
    ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
    Application.OnTime Now + TimeValue("00:01:00"), "Update"
End Sub