Location of certain Excel files


J

Jeff Hopkins

Hi,

I need to reinstall Excel2003 but I have added many micros and specialized
toolbars.

Does anyone know where this information is stored such that I may saved
those files? Thus after I reinstall Excel, I will be able to replace the
default files with these advanced versions.

Thanks,
Jeff
 
Ad

Advertisements

D

Don Guillett

IF? you are referring to personal.xls and your .xlb file, I suggest a
WINDOWS find looking for
personal.xls and another looking for *.xlb
 
Ad

Advertisements

G

Gord Dibben

Jeff

A re-install of Excel?

Or a re-install of MS Office?

Some or all of the following will apply depending upon the level of re-install.

Toolbar and Menu customizations are stored in your xxxxxx.XLB file where
xxxxxx is version-dependent name.

Excel 97.....username.xlb

Excel 2000...Excel9.xlb

Excel 2002...Excel10.xlb

Excel 2003...Excel11.xlb

Note: there may be other customizations you want to transfer at the same time.

NOTE: some settings are workbook-specific and would be stored with the
workbook.

For other global stored settings..........

Screen layout, color info, checked Add-ins and many Tools>Options
settings are stored in the Registry, not in the *.XLB file.

To see some of what's stored in the Registry have a peek at this
section in it, if you feel comfortable.

HKEY_CURRENT_USER\Software\Microsoft\Office\XX.0\Excel\Options

XX is your version of Excel...8,9,10,11

Assuming you are aware of the precautions taken when editing the
Registry and know how to restore a recent backup of same.......

If not, maybe have a look here first...scroll down to "Registry
editing tips"

http://www.activewin.com/tips/reg/index.shtml

Export all these keys(as a branch group) to a .REG file so's you can
back them up.

Note also: you may want to move over your *.ACL(autocorrect files) and any
*.DIC files.

For a more comprehensive listing see Dave Peterson's posting at

http://snipurl.com/8r7x


Gord Dibben Excel MVP


Hi,

I need to reinstall Excel2003 but I have added many micros and specialized
toolbars.

Does anyone know where this information is stored such that I may saved
those files? Thus after I reinstall Excel, I will be able to replace the
default files with these advanced versions.

Thanks,
Jeff
Gord Dibben MS Excel MVP
 

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

Top