Excel config files - where?

  • Thread starter Thread starter Steve
  • Start date Start date
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!
 
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.
 
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?
 
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.
 
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?
 
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.)
 
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.
========
 
Back
Top