Refresh Method
Refreshes the local cache of the SharedWorkspace object's files, folders, links, members, and tasks from the server.
expression.Refresh()
expression Required. An expression that returns a SharedWorkspace object.
Remarks
Use the Refresh method to ensure that you are working with the most up-to-date list of objects and their properties from the shared workspace.
Example
The following example refreshes the shared workspace if it has not been refreshed in the last 3 minutes. The example also handles the error condition where the workspace has not yet been refreshed.
On Error GoTo err_NeverRefreshed
If DateDiff("s", ActiveWorkbook.SharedWorkspace.LastRefreshed, Now) > 180 Then
ActiveWorkbook.SharedWorkspace.Refresh
End If
Exit Sub
err_NeverRefreshed:
ActiveWorkbook.SharedWorkspace.Refresh