title: Sometimes returns old (possibly cached?) values from Workbooks in SharePoint
body: <p>There are just under 2,000 excel reports in an SharePoint (Office 365) website and I am required to run a main report twice daily to get values from all of those 2,000 reports.  I use something similar to the following to get the information from these reports:</p>
  
  <pre><code>ActiveCell.Value = "='https://oursite.sharepoint.com/" &amp; path2 &amp; "/[" &amp; Filename &amp; "]Sheet1'!$D$9"
  </code></pre>
  
  <p>We define path2 / filename above which are all fine.</p>
  
  <p>This normally works fine and brings back the correct results however sometimes it'll bring old values through even though nobody has changed the reports on SharePoint.</p>
  
  <p>I don't have any prior experience to working with SharePoint other than this so was wondering if there is some automatic caching or something similar?</p>
  
  <p>If so is there a way to turn it off as we only want the latest results, perhaps something in the connection string used in Excel?</p>
  
  <p>Connection String looks like:</p>
  
  <pre><code>Provider=Microsoft.Office.List.OLEDB.2.0;Data Source="";ApplicationName=Excel;Version=12.0.0.0
  </code></pre>