ExcelBanter - Can I refresh worksheets in a specific order when I open a file?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can I refresh worksheets in a specific order when I open a file? (https://www.excelbanter.com/excel-discussion-misc-queries/253523-can-i-refresh-worksheets-specific-order-when-i-open-file.html)

begrery

Can I refresh worksheets in a specific order when I open a file?

I have multiple worksheets that contain data from MS query that I want to
refresh on open. I also have several worksheets that contain Pivot Tables
that I want to refresh on open. I want to be sure that the query worksheets
update first, then the pivot tables. Is there a way to specify what order
the sheets refresh in when the file is open?

All times are GMT +1. The time now is 11:22 PM.