Customized XL toolbar lost

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I like my excel toolbar customized. Every once in awhile
my customization goes away, and excel opens with the
standard toolbars.

Why do I keep losing my customized ones? Is there a way
to retrieve my custom settings? How can I prevent losing
them?
 
Rick

Toolbar and menu customizations are saved in *.XLB file.

Do a file search for *.XLB and locate where it(they, you may have more than
one).

Note the location(s) and make some changes to a Toolbar or menu then close
Excel and see which *.XLB is updating.

Save a copy of this *.XLB as you make changes. You can then copy it if you
lose it again.

Why are you losing it occassionally?? Are you on a network or stand-alone?
Servers can often screw up with file storage. If the *.XLB gets lost, Excel
just builds a new default one...as you have discovered.

Gord Dibben Excel MVP
 
Back
Top