Thread: linked Excel 2007 WS to Access 2007

You Cannot Open a Password-Protected Workbook

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. If you try, you receive the following error message:
Could not decrypt file.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
211378 XL2000: "Could Not Decrypt File" Error with Password Protected File

The above is from this MS link

http://support.microsoft.com/kb/257819

Alan