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.