title: Refresh an Excel workbook that uses external data from an Oracle database without user intervention
body: <p>I created an excel file that has an external connection to an Oracle database. This excel workbook has a sheet with a pivot table that allows others to extract a wealth of information/meaning from the data. </p>
  
  <p>We do not want to install the Oracle client on every users' computer who wants to use this excel workbook so we split the excel workbook into two files. One with the external data and another with just the pivot table, which references the other excel workbook with the data.</p>
  
  <p>We need the data in the excel workbook with the data to refresh periodically without having someone manually open the excel workbook with the data every time it needs to be refreshed. Any suggestions on the best way to go about this? </p>
  
  <p>e.g., maybe run a script called by Windows task scheduler that will have the datasource update?</p>
  
  <p>Thanks.</p>