XL97: Workbook Protected/Saved with a Password Is Saved Slowly

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.