# GrapeCity.Spreadsheet.PivotTables.IPivotCache.RefreshOnFileOpen

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Spreadsheet_PivotTables_IPivotCache_RefreshOnFileOpen_" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotCache.RefreshOnFileOpen*">RefreshOnFileOpen Property
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Spreadsheet_PivotTables_IPivotCache_RefreshOnFileOpen_" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotCache.RefreshOnFileOpen*"></a>
<h4 id="GrapeCity_Spreadsheet_PivotTables_IPivotCache_RefreshOnFileOpen" data-uid="GrapeCity.Spreadsheet.PivotTables.IPivotCache.RefreshOnFileOpen">RefreshOnFileOpen</h4>
<div class="markdown level1 summary"><p>Gets or sets a value indicating whether the PivotTable cache is automatically updated each time the workbook is opened.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">bool RefreshOnFileOpen { get; set; }</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Property RefreshOnFileOpen As Boolean</code></pre>
</div>
<h5 id="GrapeCity_Spreadsheet_PivotTables_IPivotCache_RefreshOnFileOpen_remarks">Remarks</h5>
<div class="markdown level1 remarks"><p>Query tables and PivotTable reports are not automatically refreshed when you open the workbook by using the Open method of the <a class="xref" href="GrapeCity.Spreadsheet.IWorkbooks.html">IWorkbooks</a> object.
Use the <a class="xref" href="GrapeCity.Spreadsheet.PivotTables.IPivotCache.Refresh.html#GrapeCity_Spreadsheet_PivotTables_IPivotCache_Refresh">Refresh()</a> method to refresh the data after the workbook is open.</p>
</div>
</div>