question

LawrenceCatherine-3151 avatar image
0 Votes"
LawrenceCatherine-3151 asked VikiJi-MSFT commented

Need to copy ALL customized settings in Office applications to new computer

I want an EXACT replica of ALL my current Microsoft Office application settings on a new computer. I would like ALL my Windows settings/customizations replicated also.

I know I can go into each program and export settings but that is extremely time consuming and to be honest, I wouldn't even know where all to look.

I have someone from my IT department that is going to transfer all my files and get me set up on the new computer, but I want all my SETTINGS to be copied also. I do not want to transfer the applications- only the settings/customizations.

I essentially want my new computer to look and function EXACTLY like my current computer without having to change each setting individually.

Is this possible? If so, can someone send me detailed info or a link that I can provide to my IT person? This is a work computer so I don't have admin permissions myself.

office-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LawrenceCatherine-3151,

From your description, the issue is related to Office applications, so I'll update this thread with right tag in order for you to get Office expertise.

0 Votes 0 ·
VikiJi-MSFT avatar image
0 Votes"
VikiJi-MSFT answered

Hi @LawrenceCatherine-3151,
Welcome to Q&A forum!
Per my research, there is currently no tool to do this. Thanks for your understanding!
Which version of Office are you using?
The following are the settings files that I think need to be copied manually.

For Office 2013,2016,365:
Word:

  1. Normal.dotm and Word document templates: in the C:\Users\<User Name>\AppData\Roaming\Microsoft\Templates folder(If do not have the AppData, please tick the Hidden items under View tab). Copy them to the same folder on the new PC.

  2. Customization file: go to File>Options>Customize Ribbon>Import/Export>Export all customizations.This will let you to save a file commonly called "Word Customizations.exportedUI". The same operation Import it to the new PC.

  3. Paragraph styles: please refer to How to import styles from one document to another?.

  4. Besides, you could aslo copy the files in C:\Users\<User Name>\AppData\Roaming\Microsoft\Office(AutoCorrect) and C:\<User Name>\AppData\Roaming\Microsoft\UProof(User Dictionaries) to the new PC as needed.

Excel:

  1. Customization file: similar procedure as above Step 2.

  2. PERSONAL.XLSB:
    For Windows 10: C:\Users\<User Name>\AppData\Roaming\Microsoft\Excel\XLSTART
    For Windows 7: C:\Users\<User Name>\AppData\Local\Microsoft\Excel\XLSTART

The above information may be insufficient, and you are welcome to point it out.
Besides, since the tag office-itpro focuses on general issues of Office client, if needed, we recommend that you post a new issue with the tag windows-10-general for professional help related to Windows.
Thank you for your understanding.

Hope the information is hepful to you.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LawrenceCatherine-3151 avatar image
0 Votes"
LawrenceCatherine-3151 answered VikiJi-MSFT commented

I am not able to reply to the comment above so I am replying here.....


YukiSun-MSFT avatar image YukiSun-MSFT · 14 hours ago
Hi @LawrenceCatherine-3151,

From your description, the issue is related to Office applications, so I'll update this thread with right tag in order for you to get Office expertise.

0 Votes0 · Reply More

This is not only Office- but Windows in general. What tag should be used for that?




· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @LawrenceCatherine-3151,
Thanks for your reply.
Tags are topics related to your thread that help group and organize all the content on Microsoft Q&A, it is recommended that a thread to correspond to a topic. And we are currently analyzing this issue from the perspective of Office.
As you said, this issue also involves Windows, and posting new questions with the tag windows-10-general will guide you to a professional team that supports Windows instead of adding it in this thread.
Thanks for your understanding!

0 Votes 0 ·

Hi @LawrenceCatherine-3151,
If you have a chance to review this thread, please accept the useful information as an answer. This action will help other users in the Q&A forum who have the similar issues.
Besides, if you have other better solutions, welcome to share with us.
Thanks for your understanding!

0 Votes 0 ·