XL2002: Detect and Repair Does Not Reset Customized Toolbar Settings

When you use Microsoft Excel 2002, and you attempt to restore the default settings by using the Detect and Repair command on the Help menu, your customized toolbar settings may not return to default as expected.

This behavior may occur even though you receive confirmation that the settings have been reset to the default settings during the Detect and Repair process.

This behavior occurs if you click Ignore when the Close Office Programs dialog box appears during the Detect and Repair process. If you do not quit Excel at this point, the customized toolbars are not reset even though you receive a confirmation message stating the defaults have been reset.

For an example of this behavior, follow these steps:

1.	Start Excel.
2.	In the Tools menu, click Customize.
3.	On the Toolbars tab, click to select all of the toolbar check boxes, and then click Close.
4.	On the Help menu, click Detect and Repair.
5.	Click to clear the Restore my shortcuts while repairing check box. Click to select the Discard my customized settings and restore default settings check box, and then click Start.
6.	When the Close Office Programs dialog box appears, click Ignore. Note the message: Reset of settings to default succeeded.
7.	Follow the remaining instructions for the Detect and Repair procedure.
8.	When the reinstallation of Office is complete, restart Excel.

Notice that the toolbar settings remain intact.

To work around this behavior, quit Excel when the Close Office Programs dialog box appears, and then click Retry to continue the Detect and Repair process.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.