File open & screen refreshes

Hi Guys, a nice easy one I think!!!!!!! When opening a spreadsheet I have requested a number of sheets to refresh upon open (ie an ODBC link and a pivot table). I need the ODBC link sheet to refresh first then, the pivot table sheer. "Law of the sod" it's happening in the wrong sequence. Quite simply how can I change the order?

Cheers

Nick