I have 2 data pages in my workbook, that are each connected to an external
data source, with 2 pivot tables, one connected to each data page.

For a complete refresh, I need to hit 'refresh all' twice.

What can I do to make it work for one 'refresh all'.

Suggestions welcome...