Excel 2007 RefreshAll

[bob_s]

Hello I'm moving from 2003 to 2007 having an issue with a macro that runs when a spreadsheet is opened and does a refresh to all for queries to an access database. It appears after the refresh command the remaining script runs in parrallel or the refreshall trumps the formating. I've used this script in 2003 and works great it's very simple. I've done a search but I've not found the answer. What am I missing? Thanks!

Private Sub Workbook_Open()
ActiveWorkbook.RefreshAll
Columns("B:B").ColumnWidth = 10
Columns("C:C").ColumnWidth = 18
Columns("D:D").ColumnWidth = 15
End Sub

 

[Derek Brown]

Hello and welcome to The Board.
My guess is that you have the Background Refresh option ticked in the queries?
I believe that this is something that you cannot override in VBA.
I use linked tables in my workbooks and, where I want processing (code/calculation etc.) to wait, I untick that option in the query properties.

 

[bob_s]

Thanks that did the trick.