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

Unless the order is based on worksheet order I don't think you can control the sequence of events that are happening when opening the workbook.

What you might be able to do is disable the automatic refresh of PT's and control them via VBA in the workbook open event.