keeping preferences after format C

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dorlaie - 17 Apr 2004 13:12 GMT

I have to upgrade to xp pro and reintall excel 2000 part
of office 2000, how can I copy the custom toolbars, etc
that I have set up now? is it in the win.ini file? Can I
copy it to the new copy of excel 2000?

Reply to this Message

Dave Peterson - 17 Apr 2004 13:33 GMT

The toolbar is kept in a file with extension .xlb. I think that it's named
excel.xlb in xl2k.

But I'd go into excel and make a slight change to the toolbar. Then exit excel.

Then use windows start button|Find/seach to look for *.xlb. Copy the one with
the latest date to a safe spot.

Don't forget your stuff in XLStart (personal.xl*) and any templates you've made.

===
I don't run WinXP, but most reinstalls of excel won't screw up *.xlb. But it
can't hurt to back it up anyway.

And to re-install your toolbar, just go into windows explorer and double click
on that *.xlb file (in the nice spot).

xl2k is very nice and will copy it to its rightful home.

> I have to upgrade to xp pro and reintall excel 2000 part
> of office 2000, how can I copy the custom toolbars, etc
> that I have set up now? is it in the win.ini file? Can I
> copy it to the new copy of excel 2000?

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Dave Peterson - 17 Apr 2004 13:42 GMT

Oops. I didn't notice the "format c" in the subject.

There's a good chance that lots of things will be gone when you do this <bg>.

I have a short list of things to copy/update when we change pc's at work.

It's not complete, but may help you.

Word/Excel files:

FileName Use
custom.dic personal dictionary
*.acl personal autocorrect list
mssp2_en.exc personal exclusion dictionary
normal.dot default (for new documents) template
*.dot Any other templates you've made

*.xlb personal toolbar
book.xlt defaults for new workbooks
sheet.xlt defaults for new worksheets
personal.xl* personal macros
*.xlt Any other templates you've made

And don't forget any:
Local files (If you dont store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)

> The toolbar is kept in a file with extension .xlb. I think that it's named
> excel.xlb in xl2k.
[quoted text clipped - 24 lines]
> Dave Peterson
> ec35720@msn.com

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message

Dorlaie - 22 Apr 2004 13:57 GMT

I know that format c things will be gone, that is why I
want to copy the toolbar and other files on a CD than copy
those files to the new formatted C drive when I reinstall
office....should work!

>-----Original Message-----
>Oops. I didn't notice the "format c" in the subject.
[quoted text clipped - 52 lines]
>> Dave Peterson
>> ec35720@msn.com

Reply to this Message

Dave Peterson - 23 Apr 2004 02:01 GMT

That was my feeble attempt at humor (at my expense) since I missed the subject.

> I know that format c things will be gone, that is why I
> want to copy the toolbar and other files on a CD than copy
[quoted text clipped - 74 lines]
> >ec35720@msn.com
> >.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message