Menu Bar

[Holsenback]

In attempting to prevent automatic recalculation in Excel, I went to Tools,
Customize and the Tools optiion disappeared from the menu. How can I restore
it?

 

[Dave Peterson]

Did you go to tools|options or Tools|customize???

If tools|options was gone, you can reset that worksheet menu bar.

Tools|customize|toolbars tab
click on worksheet menu bar
and click the reset button.

You will have to reapply any customized changes to that toolbar, though.

 

[Holsenback]

At the top of the workbook, I now have File, Edit, View, Insert, Format,
Data, Window and Help. Tools has disappeared. This is true for the entire
Excel program. The function is missing in all of my files??

 

[Dave Peterson]

Resetting the worksheet menu bar didn't remove the Tools dropdown.

But you can reset all the toolbars if you want:

close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)

Rename all the *.xlb files you find to *.xlbOLD

Then restart excel and see if that helps.

If it does, then rebuild any customized changes to the toolbar at your
convenience.

If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.

 

[Holsenback]

Problem solved. Thanks Dave. Ed Holsenback

Resetting the worksheet menu bar didn't remove the Tools dropdown.

But you can reset all the toolbars if you want:

close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)

Rename all the *.xlb files you find to *.xlbOLD

Then restart excel and see if that helps.

If it does, then rebuild any customized changes to the toolbar at your
convenience.

If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.