Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

moving normal.dot, excel customizations to new computer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
stef - 06 Oct 2007 03:43 GMT
Excel 2002 SP3
Win XP Pro

Hi,
I have customized my toolbar with custom menu items for macros, etc.
I am now migrating to a new computer with same version of Excel; but
would like to take with me the customizations, both as to tool bars and
menu items, etc.; and macros (I guess I'll have to import the files
containing the macros).
For the customizations, is it just a matter of exporting/copying a files
such as normal.dot (as in Word), etc.?
Any suggestions in helping me achieve a smooth transition and replicate
same setup on new computer as in old, would be very appreciated.
Peo Sjoblom - 06 Oct 2007 12:36 GMT
Do a windows search for *.xlb, make sure you change the default search so it
looks at hidden folders and files. Then move it to you new computer

Signature

Regards,

Peo Sjoblom

> Excel 2002 SP3
> Win XP Pro
[quoted text clipped - 9 lines]
> Any suggestions in helping me achieve a smooth transition and replicate
> same setup on new computer as in old, would be very appreciated.
stef - 07 Oct 2007 00:39 GMT
Thanks.
I imagine all of the *.xlb's need to be in the exact same location as
old computer, correct?

> Do a windows search for *.xlb, make sure you change the default search so it
> looks at hidden folders and files. Then move it to you new computer
Dave Peterson - 06 Oct 2007 12:56 GMT
Saved from a previous post:

I have a short list of things to copy/update when we changed 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)

====
I've found the easiest way to find these files is to use Windows start
button|Search.

Remember to look through hidden folders/files.  And if I find multiple files of
the same name, I open excel (say), then make a minor change to that file.  Then
search again.  Then I can pick out the current version of the file.

That said, if you're upgrading from an older version of office, I wouldn't copy
the toolbar.  (I would take good notes to help me rebuild this toolbar (maybe
even fix it up a bit).)

Same with the normal.dot (I'd let MSWord rebuild that--then just copy|paste any
macros into it manually.)

The *.xlt (book.xlt, sheet.xlt), I'd copy over, but then open and resave them
using the newer version.

> Excel 2002 SP3
> Win XP Pro
[quoted text clipped - 9 lines]
> Any suggestions in helping me achieve a smooth transition and replicate
> same setup on new computer as in old, would be very appreciated.

Signature

Dave Peterson

stef - 07 Oct 2007 00:40 GMT
Dave,
Same question as above--all of the transferred files need to be in exact
same location on new computer as they were in old computer, correct?

> Saved from a previous post:
>
[quoted text clipped - 52 lines]
>> Any suggestions in helping me achieve a smooth transition and replicate
>> same setup on new computer as in old, would be very appreciated.
Dave Peterson - 07 Oct 2007 00:53 GMT
Maybe not.

Depending on the upgrade path, the *.xlb file could be in different locations.

I like to modify the toolbar on the new pc.  Then close excel and look to see
where excel put it.  Then put the file in that location.

> Dave,
> Same question as above--all of the transferred files need to be in exact
[quoted text clipped - 56 lines]
> >> Any suggestions in helping me achieve a smooth transition and replicate
> >> same setup on new computer as in old, would be very appreciated.

Signature

Dave Peterson

stef - 07 Oct 2007 01:23 GMT
Will do.  And post back here if any difficulties.

> Maybe not.
>
[quoted text clipped - 63 lines]
>>>> Any suggestions in helping me achieve a smooth transition and replicate
>>>> same setup on new computer as in old, would be very appreciated.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.