Excel connections to Access Queries not working

[Geetarzan]

I have an Excel workbook with about 8 worksheets connected to 8 different queries in the same access DB. I want these connections to auto refresh when I open the file.

I got it all set up and I am getting an error because it is saying the DB is already open on my machine and to close it before proceeding. My guess is that it's opening the first connection to the first query and then trying the 2nd but it's not working because the first is still open. Any suggestions on what is going wrong here?

Edit to add: I've kind of confirmed my theory. If I turn off refresh on opening, and turn off refresh all on refresh, then just refresh each worksheet one by one it will work.

[dflak]

First of all, I can't reproduce the condition, but I have an idea for a work around. Turn off the background refresh and put code in an open workbook event to call them in order.

ActiveWorkbook.Connections("Connection1").Refresh

ActiveWorkbook.Connections("Connection2").Refresh
...
ActiveWorkbook.Connections("Connectionn").Refresh