Has anyone encountered the following error and what is the workaround? Basically, there were no issues with the Excel as DB connection, however, suddenly I am seeing this error. Does anyone know why this error may be encountered?


2 replies

@Fred Amiri​ Might happen if your excel was not closed properly before making connection to same Excel as DB. Make sure Excel workbook is closed.



Thank you for your suggestion, it actually ended up being that it needed a few seconds delay, in a way yes you are correct, the queries were running at a rapid speed that caused the connection to time out.


Thank you!