Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to reset Excel 2000 toolbars to "factory defaults"?
I messed up my toolbars in Excel 2000. How can I reset them to the factory defaults? I'm not talking about going to Tools/Customize and resetting each toolbar. That doesn't tell me which toolbars ARE the defaults. Isn't there a way to put everything back without reinstalling Office 2000? Thanks! |
#2
|
|||
|
|||
Hi
Try to rename your .xlb file maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb. The .xlb file has all Toolbar customization in it. Close Excel Do a search for .xlb in windows Rename the file you find (mine is named Excel10.xlb in 2002) 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 wrote in message oups.com... I messed up my toolbars in Excel 2000. How can I reset them to the factory defaults? I'm not talking about going to Tools/Customize and resetting each toolbar. That doesn't tell me which toolbars ARE the defaults. Isn't there a way to put everything back without reinstalling Office 2000? Thanks! |
#3
|
|||
|
|||
Rather than re-setting all Toolbars individually...........
Toolbar and Menu customizations and changes are stored in a file named Excel9.XLB for 2000 version. Do a file search for it. Usually stored in C:\Documents and Settings\User\Application Data\Microsoft\Excel With Excel closed rename Excel9.xlb to Excel9.old Re-start Excel and you will get factory defaults. Gord Dibben Excel MVP On 24 Mar 2005 13:03:26 -0800, wrote: I messed up my toolbars in Excel 2000. How can I reset them to the factory defaults? I'm not talking about going to Tools/Customize and resetting each toolbar. That doesn't tell me which toolbars ARE the defaults. Isn't there a way to put everything back without reinstalling Office 2000? Thanks! |
#4
|
|||
|
|||
Ron de Bruin wrote: Hi Try to rename your .xlb file maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb. The .xlb file has all Toolbar customization in it. Close Excel Do a search for .xlb in windows Rename the file you find (mine is named Excel10.xlb in 2002) Start Excel That's just what I was looking for, thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 to Excel 2003.... is it worh it? | Excel Discussion (Misc queries) | |||
Excel 2000 to Excel 2002 problem | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Can I add a borders toolbar to Excel 2000 like the one in Excel 2. | Excel Discussion (Misc queries) |