Excel Toolbar Layout
 

Every morning, when I open Excel, I rearrange the toolbars. How do I save
the arrangement so that I just have to do it once?
--
-Al

Excel Toolbar Layout
 

Al,

Excel saves its toolbar setting in a file named Excel?.xlb, where the ? is a version numbers,
depending on your specific version. You need to have read/write permission to the folder where that
file is stored, so perhaps you don't have the proper permissions. If you do, your problem may be
due to file corruption (a not infrequent occurence, unfortuantely) so try renaming the file - Excel
will re-create it with a fresh version.

HTH,
Bernie
MS Excel MVP


"CtDMonet" wrote in message
...
Every morning, when I open Excel, I rearrange the toolbars. How do I save
the arrangement so that I just have to do it once?
--
-Al

Excel Toolbar Layout
 

Since you mention Toolbars I assume you are not running Excel 2007

In earlier versions Toolbar and Menu customizations were saved in an
Excelxx.xlb file

Perhaps you do not have permission to save that file?

Or it has become corrupt?

Close Excel

Do a search for *.xlb................normally found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel

Rename it then re-start Excel.

It should save a new copy of Excelxx.xlb...............check size.

Re-start Excel

Make a bunch of customizations then quit Excel.

Check size of *.xlb..............should be larger.

Re-start Excel..................did your changes stick?


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 08:17:01 -0700, CtDMonet
wrote:

Every morning, when I open Excel, I rearrange the toolbars. How do I save
the arrangement so that I just have to do it once?

Excel Toolbar Layout
 

I tried as you said -- the file did not have a version # (named Excel.xlb).
It created a new file as expected, but it was the same size and didn't
reflect the changes. The only changes I am doing is arranging them in a
better order (covering 3 lines instead of 4). I am using Excel 2000.
--
-Al


"Gord Dibben" wrote:

Since you mention Toolbars I assume you are not running Excel 2007

In earlier versions Toolbar and Menu customizations were saved in an
Excelxx.xlb file

Perhaps you do not have permission to save that file?

Or it has become corrupt?

Close Excel

Do a search for *.xlb................normally found in

C:\Documents and Settings\username\Application Data\Microsoft\Excel

Rename it then re-start Excel.

It should save a new copy of Excelxx.xlb...............check size.

Re-start Excel

Make a bunch of customizations then quit Excel.

Check size of *.xlb..............should be larger.

Re-start Excel..................did your changes stick?


Gord Dibben MS Excel MVP

On Wed, 17 Jun 2009 08:17:01 -0700, CtDMonet
wrote:

Every morning, when I open Excel, I rearrange the toolbars. How do I save
the arrangement so that I just have to do it once?

Excel Toolbar Layout
 

I have never had 2000 installed but I believe the file name should be
Excel9.xlb for 2000 version.

I would try a search for that and move it to the appropriate folder.


Gord

On Wed, 17 Jun 2009 10:18:01 -0700, CtDMonet
wrote:

I tried as you said -- the file did not have a version # (named Excel.xlb).
It created a new file as expected, but it was the same size and didn't
reflect the changes. The only changes I am doing is arranging them in a
better order (covering 3 lines instead of 4). I am using Excel 2000.

Excel Toolbar Layout
 

No such luck. The only *.xlb file is "Excel.xlb" If I go in and change
toolbars willy-nilly, rename file to old-excel.xlb (or delete -- I've tried
both), it creates a new file called "Excel.xlb" and places it in the same
folder. When I close & re-open Excel, none of the toolbar changes remain.
--
-Al


"Gord Dibben" wrote:

I have never had 2000 installed but I believe the file name should be
Excel9.xlb for 2000 version.

I would try a search for that and move it to the appropriate folder.


Gord

On Wed, 17 Jun 2009 10:18:01 -0700, CtDMonet
wrote:

I tried as you said -- the file did not have a version # (named Excel.xlb).
It created a new file as expected, but it was the same size and didn't
reflect the changes. The only changes I am doing is arranging them in a
better order (covering 3 lines instead of 4). I am using Excel 2000.

Excel Toolbar Layout
 

Wish I had 2000 to test.

Last time I saw just Excel.xlb was version 5.0 or similar.

97(username8.xlb), 2002(excel10.xlb) and 2003(excel11.xlb) all behaved as
they should.

I really have no more for you..............sorry.


Gord

On Wed, 17 Jun 2009 13:44:22 -0700, CtDMonet
wrote:

No such luck. The only *.xlb file is "Excel.xlb" If I go in and change
toolbars willy-nilly, rename file to old-excel.xlb (or delete -- I've tried
both), it creates a new file called "Excel.xlb" and places it in the same
folder. When I close & re-open Excel, none of the toolbar changes remain.