Partilhar via


WorkbookBase.RefreshAll Method

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

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

Syntax

'Declaration
Public Sub RefreshAll
public void RefreshAll()

Remarks

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

.NET Framework Security

See Also

Reference

WorkbookBase Class

Microsoft.Office.Tools.Excel Namespace