Page is dedicated to my Excel-based scheduling and refreshing solution – Power Refresh.
As I work mainly with Excel Reporting I was seeking for the best solution to refresh Excel files on schedule / on working days / flexible / that will refresh Power Query connections / refresh PowerPivot data model / which I can adjust to handle specific needs / that does not require admin rights and so on. I gave up to find such, and decided to create my own.
It is not ideal, some expected functionality still doesn’t work, but main features work fine and allows me to handle my reporting ‘farm’.
VBA code is open, anyone can contribute or adjust it for own needs.
Latest release version is available here.