Pivot Table linked to ODBC Connection waiting for drilldown

[cogswel__cogs]

Hi,

I have a linked pivot table (Not mine) that I have manipulated to a more useful report. Original had drilldown ability, so I have another copy of original pivot to retrieve drilldown of data of new report.
It works well except the pivot table designer has limited what is returned drilldown so I have some look ups I want to attach to the drilldown.
Only when I run the macro it does not wait for the data to come across so when I try to see the range of the data in the drilldown it does not see the results yet.
Should I just write a loop to look into row 5(the first row of data) and then continue the rest of the macro after. Will this work? IS there a better way.

As always any help is greatly aprreciated.

 

[cogswel__cogs]

So I was hoping that after I ran macro and closed it. If I fired a new macro because a cell was changed in one of the sheets that the data would be there.
But even using wait to pause macro for more than enough time, and then closing that macro. Data is still not there before the change macro is fired.
So I don't think its simply timing of transfer.
Assuming it has to do with coding from excel that makes it a table as opposed to just data whjich does not run till I am done.
Maybe it happens with any pivot table.
Basically what I am trying to do is add some lookups to the right of the drilldown data. But I can't cause I don't know the size of the table to be.

 

[cogswel__cogs]

What is weird is I see the header (Non Table Format) right away in the new sheet.