Syntax

expression.Refresh

expression A variable that represents 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.

Visual Basic for Applications
 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 
ofv refresh Refresh Method

See also: