Export (0) Print
Expand All
Expand Minimize

Workbook.RefreshAll Method

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

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

void RefreshAll()

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

Show:
© 2015 Microsoft