Microsoft Office Tutorials and References
In Depth Information
If you use a password to restrict people from opening the spreadsheet, Excel
prompts you to supply the “password to open” the next time you open the file
(Figure 14-22, top).
If you use a password to restrict people from modifying the spreadsheet, the next
time you open this file you’ll be given the choice—shown in Figure 14-22,
bottom—to open it in read-only mode (which requires no password) or to open it in
full edit mode (in which case you’ll need to supply the “password to modify”).
Top: You can give a spreadsheet two layers of protection. Assign a “password
to open,” and you’ll see this window when you open the file.
Bottom: If you assign a “password to modify,” you’ll see the choices in this
window. If you use both passwords, you’ll see both windows, one after the other.
The corollary to the edict “Save your data early and often” is the truism “Sometimes
things fall apart quickly…before you’ve even had a chance to back up.” Fortunately,
Excel includes an invaluable safety net called AutoRecover.
AutoRecover periodically saves backup copies of your spreadsheet while you work.
If you suffer a system crash, you can retrieve the last AutoRecover backup even if you
never managed to save the file yourself. Of course, even the AutoRecover backup
won’t necessarily have all the information you entered in your spreadsheet before
the problem occurred. But if AutoRecover saves a backup every 10 minutes (the
standard), at most you’ll lose 10 minutes of work.
If your computer does crash, when you get it running again, you can easily retrieve
your last AutoRecover backup. In fact, the next time you launch Excel, it
automatically checks the backup folder and, if it finds a backup, it opens a Document
Recovery panel on the left of the Excel window.