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