PDA

View Full Version : Refreshing All Pivot Tables in all Worksheets



volabos
11-02-2013, 11:11 AM
Hi all,

I have few questions regrading CTRL+ALT+F5 combination to refresh all Pivot tables:

1. Does it refresh ***all Pivot tables in all Worksheets*** in a particular workbook?
2. Do I need to select a particular Pivot table before triggering that combination?
3. Can I select a particular cell in a particular Sheet, which does not contain any Pivot table, then trigger CTRL+ALT+F5. And it will refresh all Pivot tables, placed in various other Sheets?

I will really be grateful if some expert can clarify my doubts.

Thanks and regards,

mancubus
11-02-2013, 12:57 PM
hi.

afaik;
1. yes
2. no
3. yes

also you can click the Refresh All button in the Connections group in the Data tab.