changes.mady.by.user Sam Haddad [softartisans]
Saved on Jul 24, 2012
...
Public Property RefreshOnOpen() As Boolean
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xls"); Worksheet ws = wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.RefreshOnOpen = true;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xls") Dim ws As Worksheet = wb.Worksheets(0) ws.PivotTables(0).PivotTableSettings.RefreshOnOpen = true;
RefreshOnOpen is false by default.
false