Excel wont save changes to toolbar

[Guest]

I am using Excel 2000, Windows 2000....

Is it corrupt or is there a setting that somehow causes it not to save any
changes I have made to my custom toolbar?

 

[Dave Peterson]

Excel saves your customized changes in a file named *.xlb (actual file and
location will vary with your version of excel and windows).

If that file gets corrupted, it could cause trouble -- but I've never heard
anyone complain that a corrupt *.xlb file would cause this problem.

I'm guessing that you have multiple *.xlb files on your pc.

And the real *.xlb is getting saved correctly -- but you have a *.xlb that
overrides/supersedes your real one--and that one doesn't get updated.

I had a *.xlb file in my XLStart folder. My real toolbar was loaded, then
replaced with the *.xlb file in my XLStart folder. When I made changes, my real
toolbar was updated, but that didn't help the next time I opened excel. (The
file in my XLStart folder just kept superseding the real one!)

So I'd start by closing excel and looking for all the *.xlb files.

Windows|Start button|Search
look for *.xlb in hidden folders and hidden files.

You could move each *.xlb to a nice safe folder and restart excel. Then make a
minor change to a toolbar. Close excel and search again for your *.xlb files.

You'll see where the real file should be. Then it's your choice to take one of
those saved files and put it in its rightful home--or just rebuild it from
scratch.

======
On the other hand, your IT folks may have set up your pc so that you can't write
to this location. (If you used to be able to save changes to the toolbar, then
don't blame your IT folks.)

 

[Guest]

That fixed it....

The xlb file was located in the C:\....\Excel\Xlstart directory which
overrides any changes made to the xlb file located in the C:\...\Excel
directory

Thanks a bunch