Excel connections to Access refresh fail
Posted on 2013-11-27
I have a Large Excel file with multiple connections (around 60) to the same Access Database.
If i refresh them all one of them is failing with a "Unspecifid error". If i then test the connection that fails i get this message:
"Test connection failed because of an error in initializing provider"
If i then close down the Excel file and open it again, i'm able to refresh that connection without any problems.
And if I then again try to refresh all, I get the same error but now with another connection. It seams that after refreshing x-number of connection, the files fails to refresh any more.