Unless the order is based on worksheet order I don't think you can control the sequence of events that are happening when opening the workbook.

What you might be able to do is disable the automatic refresh of PT's and control them via VBA in the workbook open event.