Refresh several excel-files with own queries

[joslaz]

Hey!




I have introduced several Excel files in the company, which use Power Query to consolidate different Excel files and prepare them accordingly. The structure is as follows:




1st file:
- Query from Access
- Querys from 3 Excel files


2.-5. File:
Various Excel files.


Some of these files are updated daily with new records.
That means I have to daily in the excel files with the queries and these update.


Is it possible to outsource this somehow?
Sharepoint, server?


What ideas do you have?
Except a VBA macro which opens and refreshes the data accordingly?


Best regards

 

[Matt Allington]

For $500 you can purchase Power Update. It is worth it