GrapeCity.Documents.Excel.IPivotCache.RefreshOnFileOpen

RefreshOnFileOpen Property

RefreshOnFileOpen

Gets or sets a value indicating whether the PivotTable cache is automatically updated each time the workbook is opened.

The default value is false.

Declaration

bool RefreshOnFileOpen { get; set; }

Property RefreshOnFileOpen As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetable", 200},
    {"Fruit", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
pivotCache.RefreshOnFileOpen = true;
bool refreshOnFileOpen = pivotCache.RefreshOnFileOpen;