Update various Excel files daily

[joslaz]

Good day!

I have about 10 files that I manually open and update daily. Overall, the procedure takes 30 minutes so far.

Is there any way to outsource this update somehow?
On a kind server / Sharepoint?


What ideas would you have for me?
A macro which on an external computer in the morning each open the files and update them?



greeting

 

[TheCman81]

You could use PowerQuery to connect to each data source which will allow you to refresh them all at the same time.

https://support.office.com/en-us/ar...or-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

 

[joslaz]

Yes, thats right.

This is actually my approch.
I have 10 files with own PQ.

 

[joslaz]

Thanks!

But how can I save the different Excel-files/ Queries?

 

[joslaz]

You could use PowerQuery to connect to each data source which will allow you to refresh them all at the same time.

https://support.office.com/en-us/ar...or-excel-6e92e2f4-2079-4e1f-bad5-89f6269cd605

Do you know how to save them after the refresh?