Update Method

Updates the link or PivotTable report.

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