title: Automation of Excel activity on SharePoint
body: <p>Here is what I need to happen, without a single user action:</p>
  
  <ol>
  <li>Data resides in a csv file on a SharePoint directory.</li>
  <li>SharePoint then loads the data file into excel and refreshes pivot tables.</li>
  <li>SharePoint then copies the newly updated file to another folder on SharePoint for users.</li>
  </ol>
  
  <p>I understand I need to be using VSTO code, but I can't figure out it what I am asking for is possible.</p>
  
  <p>I can't have a user perform any of the steps in this workflow, it needs to be automated. Please assume the updated data file will be updated automatically. I appreciate all your suggestions and maybe your solution will end up in our company, Coke. ;)</p>