XL2000: "Could Not Decrypt File" Error with Password Protected File

Article translations Article translations
Article ID: 211378 - View products that this article applies to.
This article was previously published under Q211378
Expand all | Collapse all

On This Page

SYMPTOMS

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.

CAUSE

This problem may occur if all of the following conditions are true:
  • You are using the Microsoft Excel ODBC driver.

    -and-

  • The workbook for which you are creating the data source is protected by a password.

    -and-

  • The workbook for which you are creating the data source is not currently open in Microsoft Excel.

WORKAROUND

Method 1: Remove the Workbook Password

To work around this problem, remove the password from the workbook. To do this, follow these steps:
  1. Start Microsoft Excel.
  2. On the File menu, click Open.
  3. Locate and select the workbook with the password.
  4. Click Open.
  5. Enter the password for the workbook and click OK.
  6. On the File menu, click Save As.
  7. Click the drop-down arrow next to Tools, and click General Options.
  8. Delete the text in the Password to open box and click OK.
  9. Click Save. Click Yes when you are prompted to replace the existing file with the same name.
  10. Close the workbook.
You can create your data source without receiving an error message.

Method 2: Open the File in Excel

If 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.

REFERENCES

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.

Properties

Article ID: 211378 - Last Review: November 3, 2003 - Revision: 3.0
APPLIES TO
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Query 2000
Keywords: 
kbprb KB211378

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com