Automatic refresh of external data
 

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

Automatic refresh of external data
 

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.


"Texas Tonie" wrote:

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