Losing Excel Personal settings

[JGGS]

Hi

In Excel 03, I have created a number of personalized toolbars, which have
Excel buttons on them as well as macro buttons. My problem is that these
personalized buttons and toolbars disappear in certain circumstances. It may
be connected with the fact that sometimes I open two sessions of Excel at
the same time, or that I am on a company network. Whatever is the reason all
my personalized Excel settings disappear for no apparent reason.

I would appreciate if anyone out there could offer a suggestion for the
cause of this and hopefully also a way of resolving it.

Thanks a lot in advance.


Jay.

 

[Learning Excel]

Don't get your hopes up, I do not have the answer. However I want to share an
experience related to yours.
After a while trying to figure it out of why while back the same thing
happened
to me and the settings of my workbook ( at work ) keep changing and me
trying to get help from everyone, I found out "my problem":
Another coworker keeps changing my settings to his accomodation.
Have a good day.

 

[Dave Peterson]

If it's intermittent, then I don't really have a guess what you could be doing.

But if you make changes to the toolbar, then those toolbar settings will be
saved when you close excel. And if you have two sessions open, the toolbar file
will reflect the changes you made in the excel session you closed last.

If I were you, I'd search for the excel11.xlb and back it up to a nice
location. Then if the settings get lost, you can close excel and just copy that
backup version of excel11.xlb into its real home.

With WinXP Home, my Excel11.xlb was found here:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel

If you find multiple versions of that *.xlb file, I'd make an insignificant
change to the toolbar, then keep the one with the latest date modified--and
delete all the others.