Tuesday, February 15, 2011

How to Change the Password on a Shared Excel Document


1. Run Excel and open the shared document.
2. Click the 'Review' tab and click 'Unprotect Shared Workbook' under the 'Changes' group.
3. Type the workbook's password and click 'OK' to remove password protection.
4. Click the 'Share Workbook' link located on the 'Changes' tab.
5. Uncheck 'Allow changes by more than one user' on the 'Editing' tab. Click 'Yes' to unshare your Excel document.
6. Click 'File' in the menu bar, then click 'Info' and 'Encrypt with Password.'
7. Type a new password in the 'Password' box and click 'OK' to save your new password.
8. Click the 'Review' tab and click 'Share Workbook' in the 'Changes' group.
9. Click the 'Editing' tab and check 'Allow changes by more than one user' to re-enable the Excel document sharing feature.

Blogger news