XL97: File Password Lost Moving File to an Exchange Folder (158921)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Exchange 4.0
This article was previously published under Q158921 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.
WORKAROUNDMethod 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:
- Open the file in Microsoft Excel.
- On the File menu, click Save As.
- In the Save As dialog box, click Options.
- In the Save Options dialog box remove the Password to Modify password.
- Type a password in the Password to Open edit box and click OK.
- Reenter the password in the Confirm Password dialog box and click OK.
- Click Save to save your file.
NOTE: You need to consider the ramifications of saving your file with a
Password to Open password versus a Password to Modify password. Each type
of password offers different protection for your file and in some cases,
one type may be more appropriate than the other.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. This problem no longer occurs in
Microsoft Excel 2000.
Modification Type: | Major | Last Reviewed: | 5/13/2003 |
---|
Keywords: | kbprb KB158921 |
---|
|