I was reading in the forum regarding linking ODBC with excel file. I have a excel file which imports data from a website and data refreshes by itself every five mins. I had tried the ODBC connectivity with excel file closed ....it worked fine. Is there any way ODBC connectivity works with the excel file open. ?
Thanks