Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / April 2006

Tip: Looking for answers? Try searching our database.

Menu Bar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Holsenback - 21 Apr 2006 01:37 GMT
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 - 21 Apr 2006 02:07 GMT
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.

> 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?

Signature

Dave Peterson

Holsenback - 21 Apr 2006 13:19 GMT
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??

> Did you go to tools|options or Tools|customize???
>
[quoted text clipped - 9 lines]
> > Customize and the Tools optiion disappeared from the menu.  How can I restore
> > it?
Dave Peterson - 21 Apr 2006 13:59 GMT
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.

> 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
[quoted text clipped - 17 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Holsenback - 21 Apr 2006 15:03 GMT
Problem solved.  Thanks Dave.  Ed Holsenback

> Resetting the worksheet menu bar didn't remove the Tools dropdown.
>
[quoted text clipped - 35 lines]
> > >
> > > Dave Peterson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.