I have a file that when opened, it will update information from SQL scripts, it will update multiple pivot tables based off of the data imported from the scripts, and multiple charts are updated based off of the pivot charts.

In the "Connection Properties", I have the "Refresh data when opening the file" selected. In the "PivotTable Options" Data tab, I have "Refresh data when opening the file" selected.

My problem is it seems the pivot tables update before the data is updated. I keep the "Pivots" tab(this tab has all of my pivot tables on it) hidden because this file is a Dashboard that management opens and I don't want anyone messing with the pivot tables. Every Monday morning, when opened, and all the data and pivot tables are finished refreshing, the new week of information does not appear on the charts, nor on the pivot tables that is feeding the charts. I have to un-hide the "Pivots" tab, hit the refresh all, and then re-hide the "Pivots" tab.

Am I doing something wrong? How can I get the file to update properly when opened for the first time Monday mornings?

Thanks for your help.