Share via


Workbook.RefreshAll Method

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

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

Syntax

'Declaration
Sub RefreshAll
void RefreshAll()

Remarks

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

.NET Framework Security

See Also

Reference

Workbook Interface

Microsoft.Office.Tools.Excel Namespace