Refresh all in Excel

[Guest]

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?

 

[Anne Troy]

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