Excel 2007 External data refresh problem

[XLEAccessGuru]

In 2007 when I want to refresh an external data link to an Access DB, 2007 won't allow me to if the database is open, even if nothing is open in design view or in the code window. I do not have the DB set to open exclusively. Because of this I'm having difficulty automating automated external data refreshes via code in Excel 2007.

Anyone know how to correct this problem? Or is is another ingenius security "enhancement"?

 

[mrlddst]

Anyone find a solution, I'm having this issue now.