This macrow below is ran automatically when opening a file. It is supposed to refresh the data from a SQL server as well as update some pivots tables. The data is always refreshed successfully; however, the pivot tables will not update unless you run this macro once more. In another word, I have to run this macro twice before the pivot tables are updated. What is causing this?
Sub Auto_open()
'
' Auto_open Macro
'
' Keyboard Shortcut: Ctrl+q
'

Sheets("Data_FULL").Select <---Data sheet
ActiveWorkbook.RefreshAll <---Refresh data
Sheets("Table").Select <---Pivot table sheet
ThisWorkbook.RefreshAll <---Refresh pivot tables

End Sub