Excel connector not refreshing updated collections on Atlas

Hi there, I was able to connect Excel to Atlas, and pull in the existing database ‘autodb’ and collection ‘passveh’ as a data table. However, when I deleted the ‘passveh’ and inserted two new collections but these new collections are not refreshing in the excel ODBC request. Instead it still shows ‘passveh’ with no data. Any help to find out how to refresh the excel ODBC request with the new collections would be appreciated.

I had the same problem and cannot view all my collections. I tried create new DSN but still same issue. Please help