Update Method [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | LinkFormat Object | OLEObject Object | PivotTable Object