Is there a way of organizing the order in which data extracts are refreshed when 'refresh all' is selected.
Many of my workbooks have multiple extracts. when I select refresh all the popup refreshes them in an order different than they are in the data menu, and I think differently than they were created. What is the logic for this refresh order? Is there a way to change it?
My reason is that if I have 6 extracts in a workbook, often that take quite a while for each to refresh. But some of them need not be refreshed during specific times of the year. It's a management pain to do them one at a time, but if i could reorder and then cancel after the ones I needed were completed it would be a big benefit.