Procedure for Excel Refresher
Issue: My problem with the current excel refresher is that I have to be logged into the environment in order to run the tool. I need this process to work and run on a server while I am not logged into the environment.
1. Create a Pivot Report in Excel that connects to another excel file or a database
2. Save the file into a skydrive folder on a server.
3. Open up the excel refersher application and point it at the neccesary skydrive folder.
4. Setup the server task scheduler to run the new Excel Refresher tool to update the excel files.
5. Excel files refresh and push to skydrive folder external
6. All of this is done without having to be logged in to the site.