Excel97 Custom Toolbars disappeared

[Zilbandy]

I reinstalled Office 97 to fix a problem with MS Access and now my
custom toolbars that I made in Excel have disappeared. On a happy
note, my Access problem is fixed. LOL I searched for *.xlb files and
didn't find any on my hard drive. I searched an Image backup of C
drive I made yesterday and there is one .xlb file in that backup and
it's located in c:\windows (I'm using WinXP Home SP2 fully patched). I
copied this file to my current windows folders, but that didn't do
anything in helping me find the missing toolbars. I really don't want
to build new toolbars if I can avoid it. Thanks.

 

[Jim Cone]

For what it is worth...
my xl97 .xlb file is named... "User8.xlb" and is located in C:\WINDOWS.
I am also using WinXP home.
Did you close and restart XL?
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


I reinstalled Office 97 to fix a problem with MS Access and now my
custom toolbars that I made in Excel have disappeared. On a happy
note, my Access problem is fixed. LOL I searched for *.xlb files and
didn't find any on my hard drive. I searched an Image backup of C
drive I made yesterday and there is one .xlb file in that backup and
it's located in c:\windows (I'm using WinXP Home SP2 fully patched). I
copied this file to my current windows folders, but that didn't do
anything in helping me find the missing toolbars. I really don't want
to build new toolbars if I can avoid it. Thanks.

 

[Zilbandy]

For what it is worth...
my xl97 .xlb file is named... "User8.xlb" and is located in C:\WINDOWS.
I am also using WinXP home.
Did you close and restart XL?

Yes, I restarted Excel. I rebooted the computer. Didn't make a
difference. I wound up recreating the toolbars, but I hope I don't
have to do another repair installation in the future.

 

[Dave Peterson]

Find that *.xlb file and back it up to a nice spot. If you have troubles, just
copy the backup version.

 

[Zilbandy]

Find that *.xlb file and back it up to a nice spot. If you have troubles, just
copy the backup version.

That didn't seem to work. I restored that .xlb file from a backup of
my system made when all was working. Maybe I goofed. I'll play some
more.

 

[Zilbandy]

That didn't seem to work. I restored that .xlb file from a backup of
my system made when all was working. Maybe I goofed. I'll play some
more.

I must have goofed. It worked this time. I hate getting old. LOL

 

[Dave Peterson]

Maybe you restored your backup to the wrong spot.

I like to modify a toolbar, close excel and search for *.xlb. The one that has
today's date/time on it is the real *.xlb file. Make a note of its location.

I'd delete all the others (make sure you search through hidden folders for
hidden files).

And then see if you can restore your backup to that location. Use the same name
as the one you found and noted.