Detect And Repair
Office 2003 (I think) introduced a feature on the Help menu called "Detect and Repair." If an Office app is not working correctly, this command will try to fix it. I've recommended it to several people, and in just about every case it worked.
In Office 2007, the command is available in the Resources tab of the Excel Options dialog box.
Apparently, this useful tool has been removed from Office 2010. I could not find a command or button to diagnose problems. But I did find this in the Help system:
Maybe it's just a joke, added by a technical writer.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.
All Topics
Filter by Category
Subscribe
Recent Comments
Other Blogs
2