ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   restoring toolbar after re-install (https://www.excelbanter.com/setting-up-configuration-excel/252052-restoring-toolbar-after-re-install.html)

Mike Row Soft

restoring toolbar after re-install
 
I have to repair, and possibly re-install Office. There is a special Excel
file I need to save and re-open to restore my personalized toolbars, but I
forgot what it is. Where is it and what's the name?

Dave Peterson

restoring toolbar after re-install
 
It's has an extension of .xlb, but the file name and location can vary.

For me (xl2003 and WinXP Home), it's in:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel
And it's named:
excel11.xlb
(excel eleven.xlb)

With excel open, make a minor modification to a toolbar (to find "true" toolbar
file).

Then

Close excel
use windows search to look for *.xlb
and delete all that you find (or move them to a safe location if you're worried)

And remember to look through hidden folders, too. People can have trouble
finding them.

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Keep the *.xlb file that was just changed and delete the others.

(There could be multiple *.xlb files depending on your excel upgrade path.)



Mike Row Soft wrote:

I have to repair, and possibly re-install Office. There is a special Excel
file I need to save and re-open to restore my personalized toolbars, but I
forgot what it is. Where is it and what's the name?


--

Dave Peterson


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com