Sets or returns whether Microsoft Excel will automatically refresh a pivot table and the pivot table cache when Microsoft Excel opens the document.

 public boolean RefreshOnOpen{ get; set; }
Public Property RefreshOnOpen() As Boolean

RefreshOnOpen is false by default.