A few days ago, I outlined some changes that had been made to Tools|Options. Today, I wanted to run through how the options were organized for those of you that are curious, and point out one other feature I forgot to mention Monday. Since we already looked at the â€œPersonalizeâ€ tab, letâ€™s start with the Formulas tab.
As you can see, the most commonly changed options are available here. (Harlan, I think you made a comment about many of the options on the â€œPersonalizeâ€ tab being new â€“ to be clear, it wasnâ€™t just the â€œPersonalizeâ€ tab I was talking about, it was the first several tabs. Sorry, I should have been clearer â€¦ you can see that most of the options on the “Formulas” tab are not new.) You can also see that options dealing with multi-threaded calculation are not featured here, since those are items we expect most users never to change. Next, here are â€œProofingâ€ and â€œSaveâ€.
On the â€œSaveâ€ tab, you may have noticed that there is a drop-down in the â€œAutoRecover exceptions for:â€. This is the other feature I forgot to point out earlier this week. We have tried to make it clearer what the â€œscopeâ€ of options are â€¦ for example, where an option applies only to a workbook, we make that clear, and allow users to set the option for any open workbook. Same for worksheets, etc. For a certain set of users, this has proven to be quite helpful.
Next, here is a glued-together image of everything in â€œAdvancedâ€. Normally you would have to scroll to see all of this, but to make it viewable on the web, I combined the bitmaps in paint.
â€œCustomizationâ€ is where you can add, subtract, and remove commands from the â€œQuick Access Toolbarâ€.
â€œAdd-Insâ€ shows you installed add-ins and allows you to manage them, and â€œTrust Centreâ€ is something I will cover in a later post.
Finally, the â€œResourcesâ€ tab is where you can trigger updates, diagnose problems, register things, identify your version, etc.