Summary

In this chapter, you learned about several ways to set up a series of defenses against mishaps in your Excel spreadsheets. Undo and Redo allow you to quickly respond at that moment, unless an Excel command or feature removes that safety net without notice. The AutoRecover and AutoSave commands enable you to for keeping backup copies of your work offline or in the cloud, respectively. The Always Create Backup setting provides an additional fallback position for critical workbooks that are saved locally.

Also, you saw how to dispatch the flurry of warning prompts that can appear when you open an Excel workbook that contains data connections, workbook links, or macros. Well-intentioned security prompts can interrupt your workflow or worse, stymy your work if you don’t understand the prompt.

We’ll continue our quest for improved productivity in Chapter 3, Quick Access Toolbar Treasures, where I’ll show you how to streamline common tasks with icons and...