• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

refresh pivot tables from 2nd excel workbook

Hi Expert's

having trouble sometimes when I try to refresh 11 pivot tables from a 2nd excel workbook...whats the best way to do this each time the destination 1st workbook is opened...

and also how can you review what wrkbook the pivot tabke is linked to??
0
route217
Asked:
route217
1 Solution
 
Rgonzo1971Commented:
Hi,

Have you tried PivotTableTools  / Options / Data / Refresh All ?

To Know the data Source

Goto
PivotTableTools  / Options / Data / Change Data Source

Regards
0
 
route217Author Commented:
Manythanks for the feedback. .
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now