<div>
Hi...rgnonzo1971..<br />
<br />
not sure I follow
</div>


<div>
Is is more comprehensible?<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-39764935-1"><span>Sub Macro()</span>
<span></span>
<span>ThisWorkbook.RefreshAll</span>
<span></span>
<span>End Sub</span>
</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
Hi expert's excel 2007<br />
<br />
I have 17 pivot tables in a worksheet. ...I need a macro to refresh all as opposed to refreshing each one in turn...
</div>
</div>


Hi expert's excel 2007

I have 17 pivot tables in a worksheet. ...I need a macro to refresh all as opposed to refreshing each one in turn...

macro to refresh all pivot tables

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