Page 472 - Excel 2013 All-in-One For Dummies

454 Protecting the Spreadsheet
If you enter a password in this text box (and you should — otherwise, there’s little reason to use this option, because anyone can remove the protection from the shared workbook and thus stop the file sharing), Excel immediately displays the Confirm Password dialog box, where you must accurately reproduce the password.
When you do this, Excel displays an alert dialog box that informs you that
it will now save the workbook, and when you click the Yes button, the pro- gram saves the workbook as a shared file and protects it from being made exclusive without the password. The program also adds a [Shared] indicator to the filename at the top of the Excel program window to let you know that the workbook is being shared.
To remove the protection from the shared workbook and, at the same time, stop sharing it, you choose the Unprotect Shared Workbook command button (that replaces the Protect Sharing button) in the Changes group on the Review tab of the Ribbon. After you enter the password to unprotect the file in the Unprotect Sharing dialog box and click OK, Excel displays an alert dialog box, informing you that your action is about to remove the file from shared use and erase the Change History log file. If you click Yes, you prevent users who are currently editing the workbook from saving their changes. If you’re sure that no one else is using the workbook, you can con- tinue and remove the file sharing by clicking the Yes button.