Excel config files - where?

S

Steve

Installing Excel on a new computer, want to copy over the config
files, not sure which these might be or where they're located. ?

Thanks!
 
H

Harlan Grove

Installing Excel on a new computer, want to copy over the config
files, not sure which these might be or where they're located. ?
Click to expand...

I'll guess you mean the *.XLB files and anything in the default and alternative
startup directories on the old machine. These include only a few user settings.
Most user settings are stored in the Registry.
 
S

Steve

Harlan Grove said:
I'll guess you mean the *.XLB files and anything in the default and alternative
startup directories on the old machine. These include only a few user settings.
Most user settings are stored in the Registry.
Click to expand...

Yes, sorry, I mean sorta the Excel equivalent of Word's normal.dot,
with my macros, font settings, etc. Is this stuff not available for
file transfer?
 
T

Tom Ogilvy

Excel doesn't have a normal.dot equivalent. Macros are stored in individual
workbooks. The personal.xls stored in the xlStart directory may be where
your macros are stored if you didn't overtly store them somewhere else and
they were generated by recording a macro.

As Harlan stated, most settings are stored in the registry.
 
S

Steve

Tom Ogilvy said:
Excel doesn't have a normal.dot equivalent. Macros are stored in individual
workbooks. The personal.xls stored in the xlStart directory may be where
your macros are stored if you didn't overtly store them somewhere else and
they were generated by recording a macro.
Click to expand...

Copied the personal.xls file to \Docs &
Settings\AppData\MS\Excel\XLStart - still no macros. Should that file
maybe be copied somewhere else?
 
D

Dave Peterson

The location of your XLStart folder varies with versions of excel and windows.

You could record a dummy macro into personal.xls and then save it. Then use
windows|Find to search for it to see if you got the right spot.

or you could open excel, hit alt-F11 to get to the VBE and then ctrl-G to see
the immediate window.

Then type this and hit enter:

?application.startuppath

I got this:
?application.startuppath
C:\WINDOWS\Application Data\Microsoft\Excel\XLSTART

(but don't use my location.)
 
D

Don Guillett

Just to add to this from my memory of a similar problem.
You could record a dummy macro into personal.xls and then save it. Then use
windows|Find to search for it to see if you got the right spot.
Click to expand...

Test the dummy first to make sure it is working properly
and then copy YOUR old personal.xls over the newly created one that you
found.
BTW. Make sure you don't have another one you are trying to use.
Hope this makes some sense.
========
 
Top