I wrote a small Command line utility to refresh Excel documents and their external connections, query tables and pivot tables. I use it via Task Scheduler to update a bunch of Excel based Dashboards which are then shared via Sharepoint.
The executable and C# Visual Studio project are here: https://github.com/alapolloni/ExcelRefresh
Hoping it's as useful to someone else as lots of the Q&A here have been to me.
Feedback welcome.
Regards,
Alex
Bookmarks