Update Method
Updates the link or PivotTable report.
expression.Update
expression Required. An expression that returns an OLEObject or PivotTable object.
Example
This example updates the link to OLE object one on Sheet1.
Worksheets("Sheet1").OLEObjects(1).Update