Refresh all in Excel
 

When I use 'refresh all' on the External Data toolbar, it only refreshes the
external data page, and not the adjoining pivot table. I need to click
'refresh' on the pivot toolbar as well in order for the pivot to display the
new information.

How can I get around this two-step?

Refresh all in Excel
 

You could easily record a macro to do both for you. This should help:
http://vbaexpress.com/kb/getarticle.php?kb_id=80
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Texas Tonie" wrote in message
...
When I use 'refresh all' on the External Data toolbar, it only refreshes
the
external data page, and not the adjoining pivot table. I need to click
'refresh' on the pivot toolbar as well in order for the pivot to display
the
new information.

How can I get around this two-step?