Update Method

Microsoft Excel Visual Basic

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