XL97: File Password Lost Moving File to an Exchange Folder

• Microsoft Excel 97 for Windows
• Microsoft Exchange, Version 4.0

SYMPTOMS

When you open a password protected Microsoft Excel workbook from a Microsoft Exchange folder, the file may open without displaying a dialog box asking you for the password.

CAUSE

When you move a Microsoft Excel workbook into a Microsoft Exchange folder, the security attributes of the Password to Modify option assigned in Microsoft Excel are ignored.

NOTE: If you saved your Microsoft Excel file with a Password to Open option, you are prompted for this password when you open your file from an Exchange folder.

WORKAROUND

Method 1: Place File in a Secure Exchange Folder

Microsoft Exchange provides its own set of security attributes for Microsoft Exchange folders. If you want to restrict access to a Microsoft Excel file in a Microsoft Exchange folder, you must place the file in an Exchange folder that has the appropriate file/share security.

Method 2: Change the Type of Password Protection

Change the password protection type to Password to Open. To do this with a file that already has Password to Modify protection, do the following:

1. Open the file in Microsoft Excel.

2. On the File menu, click Save As.

3. In the Save As dialog box, click Options.

4. In the Save Options dialog box remove the Password to Modify password.

5. Type a password in the Password to Open edit box and click OK.

6. Reenter the password in the Confirm Password dialog box and click OK.

7. Click Save to save your file.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.