How do I password protect my Excel Workbook and create a backup of the original in Excel 2007? You can set the password on your Excel workbook so nobody can open up your workbook without the password, or a password to read. Meaning everybody can open up your workbook, but without the password nobody can make changes only read the contents. You can even do a combination of both password to open the workbook, and then another password to modify. Additionally, you have the option to always create a backup copy of original workbook with an .xlk extension, after each and every time you edit and then save your workbook. See our training videos!

Purchase the training video and you can see this in action for yourself!