<div>
Manythanks for the feedback. .
</div>


<div>
<div class="content wysiwyg-content">
Hi Expert's<br />
<br />
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...<br />
<br />
and also how can you review what wrkbook the pivot tabke is linked to??
</div>
</div>


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

refresh pivot tables from 2nd excel workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.