Refresh all in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
Back
Top