If the Excel workbook is protected by a password, you cannot open it for data access, even by supplying the correct password with your connection settings, unless the workbook file is already open in the Microsoft Excel application.

so, you cán link it, but when you want to access the data, the excelsheet has to be opened in excel, then it does work