XL97: Workbook Protected/Saved with a Password Is Saved Slowly (168199)



The information in this article applies to:

  • Microsoft Excel 97 for Windows

This article was previously published under Q168199

SYMPTOMS

When you save a workbook in Microsoft Excel 97, it may take a long time to save the workbook.

CAUSE

This problem occurs if either of the following conditions is true:

  • You click Save AS on the File menu, click Options, and then type a password in the Password To Open box. -or-

  • You protect the workbook with a password by clicking the Tools menu, pointing to Protection, and clicking Protect Workbook.
For example, a workbook without a password that takes three seconds to save may take over two minutes to save when you apply a password or when you protect the workbook with a password.

NOTE: Microsoft Excel 97 for Windows, Service Release 1 saves a file containing a password approximately 50% faster than the original release of Microsoft Excel 97.

This problem occurs because of the way that Microsoft Excel 97 applies encryption to a workbook when you apply a Password To Open password or when you protect the workbook with a password.

NOTE: Applying a Password To Modify password to the workbook does not cause this problem to occur.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 for Windows, Service Release 1.

MORE INFORMATION

In Microsoft Excel 97, you can apply a password to a workbook by following these steps:

  1. Open or switch to the workbook.
  2. On the File menu, click Save As, and then click Options.
  3. In the Save Options dialog box, specify a password in the Password To Open and/or the Password To Modify box. Then, click OK.
  4. Confirm each password by reentering it and clicking OK.
  5. Click Save to save the workbook with the password(s).
If you apply a Password To Open password to a workbook, you cannot open the workbook without providing the password. If you apply a Password To Modify password to a workbook, you cannot save changes to the workbook without providing the password. If you do not know the password, you can still save the workbook by using a different file name.

To protect a workbook in Microsoft Excel 97 do the following:

  1. Open or switch to the workbook.
  2. On the Tools menu, point to Protection, and then click Protect Workbook.
  3. If you want, type a password in the Password box and click OK. If you are prompted, reenter the password and click OK again.
Protecting a workbook in this way does not prevent other users from opening the workbook or from saving it with its original file name. However, it does prevent other users from changing the structure of the workbook or from moving its window on the screen unless they know the password.

Modification Type:MajorLast Reviewed:11/9/2000
Keywords:kbprb KB168199