Hello there! I have been days looking for a solution to my problem.
Y have a complex tool in excel that uses information from 20 different datasources loaded in Power Pivot.

Thing is, that queries bringing iformation from DataBase have date ranges. And it is very annoying edit every connection to edit the query and update the data range every time. It takes for ever.

Solution I am needing is to have a simple table in the main excel file, where I have the dates for each data source.
What I need is, load all the dates in this excel table, and then using VBA modify all the queries from the datasources working in Power Pivot.

I dont know if I was clear enough. If not, let me know.

Thank you for your help!