Partager via

_Workbook.RefreshAll Method

  • Article

Refreshes all external data ranges and PivotTable reports in the specified workbook.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub RefreshAll
'Usage
Dim instance As _Workbook

instance.RefreshAll()

void RefreshAll()

Remarks

Objects that have the BackgroundQuery property set to True are refreshed in the background.

See Also

Reference

_Workbook Interface

_Workbook Members

Microsoft.Office.Interop.Excel Namespace