<div>
If I understand what you said, it sounds like the macro is &quot;refreshing all&quot; pivot tables before the ODBC is updated. &nbsp;The order of execution should be reversed. &nbsp;I believe the &quot;refresh all&quot; command is probably only related to all the pivot tables and not the raw data from the ODBC. &nbsp;That would be my guess.
</div>


If I understand what you said, it sounds like the macro is "refreshing all" pivot tables before the ODBC is updated.  The order of execution should be reversed.  I believe the "refresh all" command is probably only related to all the pivot tables and not the raw data from the ODBC.  That would be my guess.

<div>
Thank you everyone for your help
</div>


<div>
<div class="content wysiwyg-content">
I have a spreadsheet with two tabs.<br />
Tab 1 is a Pivot table of Tab 2<br />
Tab 2 is created via a connection through ODBC<br />
<br />
I have a macro that request to refresh all but the summary pivot table is being refreshed first so it does not reflect the details which have not yet been refreshed. &nbsp;The details then are refreshed and accurate but the pivot table is not.<br />
<br />
By refreshing again, the pivot table does reflect the details that are now accurate.<br />
<br />
Does anyone know how to address this?
</div>
</div>


I have a spreadsheet with two tabs.
Tab 1 is a Pivot table of Tab 2
Tab 2 is created via a connection through ODBC

I have a macro that request to refresh all but the summary pivot table is being refreshed first so it does not reflect the details which have not yet been refreshed.  The details then are refreshed and accurate but the pivot table is not.

By refreshing again, the pivot table does reflect the details that are now accurate.

Does anyone know how to address this?

Excel Macro Pivot Table

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

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