Refresh Method

  • Article

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

Applies to | SharedWorkspace Object