Excel Customisations

G

Gord Dibben

Gummo

Do a file search for *.XLB and copy that to a safe place for re-loading on
your re-formatted PC.

Name and folder placement is version-dependent.

Excel 97 is username.xlb and stored in Windows folder.

Excel 2000 is Excel9.xlb and usually in

X:\Documents and Settings\User\Application Data\Microsoft\Excel

Excel 2002 is Excel10.xlb in same path as Excel 2000(I believe)

Gord Dibben XL2002
 
D

Dave Peterson

Just to add to Gord's reply:

I have a short list of things to copy/update when we do this at work. It's far
from complete, but it gets most of the stuff.

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 (*see the note below)
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 don’t store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)
 
G

Gord Dibben

Good list Dave.

Filed away.

Gord

Just to add to Gord's reply:

I have a short list of things to copy/update when we do this at work. It's far
from complete, but it gets most of the stuff.

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 (*see the note below)
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 don’t store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)
Click to expand...
 
D

Dave Peterson

We're getting new laptops at work. It scares me about how much stuff I'm gonna
miss.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Only install certain apps in Microsoft 365 for Enterprise? 0
Custom Fonts in Powerpoint for Mac 0
Direct emailing a word 2007 page 0
Customised ribbon with buttons 1
Excel buttons change macro file name when run on other computers 7
Customisable Word Teamplate 0
Copy quick access bar to another PC? 4
Excel file won't save to iCloud on Mac 0

Top