Option to have Refresh All actually refresh 'all'
In Excel 13 & 16, I have not been able to get Data > Refresh All > Refresh All to actually refresh all the pivot tables, slicers and data (via PQ). It would be great to have an option where 'Refresh All' literally refreshes everything. Otherwise, you have to refresh the data, then go to each pivottable and refresh individually.
Mike C commented
The 'Refresh All' feature does do this. The problem is that it seems to take an "on your mark get set go" approach where everything runs at the same time. So if you have pivot tables as well as external data connections, the pivots will refresh a lot more quickly without waiting until the external data connections are finished. This makes it look like the pivots never refreshed, although they did. The only solution I've found is to run the 'Refresh All' twice. It would be nice if there was a way to order the refreshes in a way that makes sense without using VBA...