Article ID: 211378 - View products that this article applies to.
This article was previously published under Q211378
When you try to create a data source for a Microsoft Excel for Windows workbook, you may receive the following error message:
Could not decrypt file.
This problem may occur if all of the following conditions are true:
Method 1: Remove the Workbook PasswordTo work around this problem, remove the password from the workbook. To do this, follow these steps:
Method 2: Open the File in ExcelIf you have the password protected workbook open in Microsoft Excel, you will be able to successfully create a data source for this workbook. However, you must have this workbook open when you use this data source or when you refresh a query that is pulling data from this data source.
For more information about protecting your workbook, click Microsoft Excel Help on the Help menu, type Protect workbooks from changes in the Office Assistant or the Answer Wizard, and then click Search to view the topic.