Controll Order of Data Refresh
I've set my data connections, queries, and pivots to refresh when I open the file. The issues is I can't find a way to control the order, so a pivot or dependent query may refresh before the sources/non-dependent data is refreshed. This is solved by running a second refresh all, but that is time consuming and reliant on user remember to do it. It's difficult to write a macro for because refresh times vary. If a method doesn't already exist it would be helpful if refresh was based on dependency in the data model or relationships pivots or queries have to source data.
An absolute must. Causes me no end of problems.
Mike C commented
OMG please please please. This has been bugging me for years. I've tried several things people have suggested in forums, that simply don't work, such as Application.CalculateUntilAsyncQueriesDone (VBA), turning off Enable Background Refresh (connection properties), and DoEvents (VBA). None of this seems to have an effect. I need all external data connections to refresh first, then refresh pivot tables linked to those connections, then recalculate the workbook/dependency tree. My solution has been to do the same as above; run the refresh twice, which is an inefficient use of time and hardware resources.