I created a workbook with two sheets. In sheet1 there is a table connecting
to an external data source (From Sql Server). Sheet2 has a pivot table of
which ithe data are bases on the table of sheet1.

Now when I click the refresh all button to refresh all objects in the
workbook, the order is refresh pivot table first, and then the table of
external data. So we have to refresh all again or refresh the pivot table
individually.

Is this a bug? Can we manually change the refresh order to refresh external
data first, then the pivot table based on it?