A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

restoring toolbar after re-install



 
 
Thread Tools Display Modes
  #1  
Old December 29th, 2009, 10:40 PM posted to microsoft.public.excel.setup
Mike Row Soft
external usenet poster
 
Posts: 44
Default 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?
  #2  
Old December 29th, 2009, 11:16 PM posted to microsoft.public.excel.setup
Dave Peterson
external usenet poster
 
Posts: 19,791
Default 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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.