December 9

Link a password protected excel spreadsheet to an access database

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

Copyright 2019. All rights reserved.

Posted 09/12/2016 by jiangws in category "Excel for Busy People