Give File Time to update Pivot Table when started bij Macro
 

An application I wrote (Macro) in book 1, loads Book 2 and get's back to Book
1 directly after. Book 2 updates his pivot tables automaticly at opening,
though the application does not give Book 2 enough time to do so. Further on
in the application this causes complications.

My question: "How do I make sure that the application gives book 2 enough
time to update it's pivot tables, before returning to book 1?

THANKS IN ADVANCE!