I have tons of reports that import data from MSSQL, then based on this data there are also tons of pivot tables.

I set both SQL data sources and pivot tables to refresh after the file is opened, but of course it has to work in a retarded way
First it refreshes the pivot tables and then the SQL data.. So the pivot tables are not showing the latest data in the end.

Any solutions for that?
VBA is also an option..

Thanks!