Menu Bar
 

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?

Menu Bar
 

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 wrote:

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

Menu Bar
 

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" wrote:

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 wrote:

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

Menu Bar
 

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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson

Menu Bar
 

Problem solved. Thanks Dave. Ed Holsenback

"Dave Peterson" wrote:

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 wrote:

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" wrote:

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 wrote:

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


--

Dave Peterson