Hello,
I have a connection to another excel file. Where I bring in data.
In my code, I refresh the connection. then update a pivot table.
It appears that the code goes so fast that it calls refresh, and while it refreshes the pivot table gets called.
Thus my pivot table has old data.

I looked at this
http://msdn.microsoft.com/en-us/libr.../ff834459.aspx

And my code now looks like this

Please Login or Register  to view this content.

but it does not seem to work.

any ideas on delaying till refresh is done?

thanks