Settings Backup

  • Thread starter Thread starter 24C
  • Start date Start date
2

24C

I am using Microsoft Office 2007 Professional. I'd like to know if there is
a program to back up the settings in Excel (other office programs a bonus).
I'd like to be able to re-install Excel/Office and be able to re-install all
the program settings.

TIA
 
These instructions are for Office 2003 but most will apply to 2007

Here is a list from Dave Peterson...............

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

End Dave............................

Note: Excel also stores a lot of settings in the registry. Most at

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options


Gord Dibben MS Excel MVP
 
Thanks - good info



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
These instructions are for Office 2003 but most will apply to 2007

Here is a list from Dave Peterson...............

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 don't store on LAN)
(Settings) Directories and other defaults (Tools|Options stuff)

End Dave............................

Note: Excel also stores a lot of settings in the registry. Most at

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options


Gord Dibben MS Excel MVP
 
I'm not sure if this applies to Office 2007, but...

In Office 2003, there's an option in the "Microsoft Office" program group (under
windows start button), then "Microsoft Office Tools", then "Microsoft Office
2003 Save My Settings Wizard"

You may want to see if Office 2007 has the same feature (I didn't look).
 
I looked for that - can't find it.


I'm not sure if this applies to Office 2007, but...

In Office 2003, there's an option in the "Microsoft Office" program group
(under
windows start button), then "Microsoft Office Tools", then "Microsoft Office
2003 Save My Settings Wizard"

You may want to see if Office 2007 has the same feature (I didn't look).
 
I know that I never used it in xl2003. Maybe there wasn't enough interest to
keep it in any future version.
 
On XP with 2003 - look under:

Start- All Programs- [a sub-folder if you have one] - MS Office - MS Office
Tools

Eric
 
But the OP is using xl2007.
On XP with 2003 - look under:

Start- All Programs- [a sub-folder if you have one] - MS Office - MS Office
Tools

Eric

Dave Peterson said:
I'm not sure if this applies to Office 2007, but...

In Office 2003, there's an option in the "Microsoft Office" program group
(under
windows start button), then "Microsoft Office Tools", then "Microsoft
Office
2003 Save My Settings Wizard"

You may want to see if Office 2007 has the same feature (I didn't look).
Click to expand...
Click to expand...
 
24C said:
I am using Microsoft Office 2007 Professional. I'd like to know if there is
a program to back up the settings in Excel (other office programs a bonus).
I'd like to be able to re-install Excel/Office and be able to re-install all
the program settings.

TIA
Click to expand...


Hi. I've never used either, but some ideas to explore...
In Windows Vista...

Open "Windows Easy Transfer" by clicking the Start button , clicking All
Programs, clicking Accessories, clicking System Tools, and then clicking
Windows Easy Transfer.

‌Others have mentioned going to Microsoft's Download page, and using...

"Windows User State Migration Tool (USMT) Version 3.0.1"

Good luck.

Dana DeLouis
 
After alot of trial and error, I figured out how Office 2007 saves the
customized Quick Access Toolbar in Windows XP. Note that I'm only talking
about the TOOLBAR menu settings in excel, word and powerpoint, etc., and NOT
the internal options settings in those programs. So the toolbars for Excel,
Word, PowerPoint 2007 are each saved in a separate ".QAT" file (stands for
Quick Access Toolbar), in the following directory on Windows XP:

C:\Documents and Settings\(User Name)\Local Settings\Application
Data\Microsoft\Office

The files you need are: Excel.qat, PowerPoint.qat, Word.qat.

FYI, the Local Settings folder is hidden by default on WinXP.
To backup your toolbar settings, just save a copy of these files. I tested
the Excel.qat by copying it from one computer to another (same directory),
and I got my custom toolbar.

On Vista I'm not sure where those files are stored, but you can just search
for .QAT files on C drive. Make sure you include "hidden" files in your
search.

I'll keep trying to figure out the other settings...
 
OK, the settings for all Office 2007applications are in the registry here:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0

So, you could just export that registry tree to a .REG file and store it.
When you need to get your settings back (after reinstall or on another
computer), just double click on the .REG file.

Again, this is for XP registry, not sure about Vista at this point.
 
I had to replace my hard drive. I reinstalled Office 2003. I need to move
scores of Excel toolbar customizations from my backup folder. How do I do
this?
 
If the changes you've made to the toolbars are just built-in icons
(tools|customize), you can find your *.xlb toolbar file and paste it into the
correct folder.

I like to make a minor change to a toolbar, then close excel and search for the
*.xlb file. Then I'll know for sure which *.xlb file excel wants to use.

If the changes you've made to the toolbars point at macros that you've written,
you'll have to do more work. You'll have to find those workbooks that contain
the macros and reassign (or at least verify) the macros to point to those files.

Personally, I would rebuild the toolbar with the built in icons. There's lots
of things that I don't use and many that I may want to add. It never hurts to
clean up those toolbars.

And if I'm assigning macros to the toolbars, I wouldn't do it manually. I'd do
it via code.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm
 
It'll vary with the version of excel and windows.

For me (xl2003 and WinXP Home), it's in:
C:\Documents and Settings\David Peterson\(username)\Microsoft\Excel

I can get to that location quickly by:
Windows start button|Run
type:
%appdata%
and drill down through Microsoft to Excel

Another way...

If you can't find your files using windows start button|Search, then you could
use an old DOS command to search and delete/move them

Windows Start button|Run
type:
CMD
(to get to the Command prompt)

C:
(to get to the C: drive--change this to the drive that excel is installed on)

cd\
(to get to the root directory)

dir *.xlb /s

The /s says to search subfolders, too.

Make a note of the locations of the found files.
 
Back
Top