Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
isabella9
 
Posts: n/a
Default Excel Menubar/File Category Lost

Trying to customize my menubar, I managed to removed the file category. I
have been unable to restore it although I have tried numerous options,
including: Tools, customize, options, reset, as well as Tools, customize,
toolbars, reset.
Does anyone know how I can restore my original menubar settings? Tx.
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

Hi

Try this then if you try to reset in manual

Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows
3. Rename the file you find (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"isabella9" wrote in message ...
Trying to customize my menubar, I managed to removed the file category. I
have been unable to restore it although I have tried numerous options,
including: Tools, customize, options, reset, as well as Tools, customize,
toolbars, reset.
Does anyone know how I can restore my original menubar settings? Tx.



  #3   Report Post  
isabella9
 
Posts: n/a
Default

Ron, you're a genius!!!! None of the tech folks at my job could figure this
out!

THANK YOU!

Miriam

"Ron de Bruin" wrote:

Hi

Try this then if you try to reset in manual

Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows
3. Rename the file you find (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"isabella9" wrote in message ...
Trying to customize my menubar, I managed to removed the file category. I
have been unable to restore it although I have tried numerous options,
including: Tools, customize, options, reset, as well as Tools, customize,
toolbars, reset.
Does anyone know how I can restore my original menubar settings? Tx.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text in Excel is lost PGP Excel Discussion (Misc queries) 3 June 14th 05 09:22 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
how to convert GETPIVOTDATA from excel 2000 to excel 2002... Need_help_on_excel Excel Worksheet Functions 1 March 15th 05 01:08 AM
I get a program error when I download an excel template Ladybug Excel Discussion (Misc queries) 3 March 4th 05 12:02 AM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"