Automatic refresh of external data

[Guest]

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...

 

[Guest]

You can change the "refresh" properties on the underlying data query by
selecting data range properties on the query. A simple right click while
highlighting a cell in the output will get you into the properties screen.