i lost my menu bar in excel

[Guest]

I have lost everything at the top of my excel page. No edit, file, toolbars,
or anything. The shortcut keys seem to work. I don't remember doing
anything to it. Can anyone help?
Brian

 

[Frank Stone]

hi,
Go to View>toolbars
Click the toolbars you want. this will get your tool bars
back but i don't know what made them disappear.
Regards
Frank

 

[Guest]

Hi Brian,
In case if Frank's solution doesn't work because you can't get to the menu
bars at all try this earlier post by Dave Peterson:

Close excel
windows start button|search/find
look for *.xlb
rename all of them *.xlbOLD

then reopen excel and test it out.

If it worked ok, search for *.xlbOLD and delete them.

If it didn't, rename them back to *.xlb.

 

[Guest]

Thanks for the try. Neither one worked. I have no menu bar, so no file tab.
I did the search, and it came up with one match at Excel, but no individual
files. When I open that I get a grey screen that says "Microsoft Excel" at
the top; everything else is blank. ????

 

[Myrna Larson]

Just one more step: if it didn't work, you may have to delete the new XLB file
that Excel created before you can rename.

 

[Guest]

Brian,
Sorry to hear it isn't working.
You might want to try to follow this lin
http://groups.google.com/groups?q=m...y=2004&[email protected]&rnum=25

Beyond that I am at a loss as to how to further direct you. Maybe someone
else has run into this. Perhaps it is a registry issue??

Best wishes.

 

[David McRitchie]

Actually if you just lost the toolbars, and immediately are aware of the
fact, you would not close excel but
open your .*.xlb file with Excel still open to replace what you are
using with what you had when you previously used Excel.(when Excel last opened/closed)
http://www.mvps.org/dmcritchie/excel/toobars.htm#emergency

Once you've closed Excel, you would want to try to find out what you had
done and correct that, if possible, before resorting to renaming your
*.xlb file and having Excel create a new one. All of your toolbar customizations
and your own icons, and menus are stored in that file. You should be
including it in your backups.
http://www.mvps.org/dmcritchie/excel/backup.htm

But from what you describe possibly you are in Full Screen mode
View, click on Full Screen mode to turn on or off