Note: The other languages of the website are Google-translated. Back to English
English English

How to find and change default save location of Excel templates?

If you want to export all of personal Excel templates to a new computer, how to find out the Excel templates quickly? If the default saving location is too hard to find out quickly, how to change the default save location? In this article, I will show you detailed ways to find out the default save location of Excel templates, as well as change the default save location of Excel templates.

Find out the default save location of Excel templates

To find out default save location of your personal Excel templates, just copy and paste the following path into the Address box of a folder window:

Excel 2013’s personal templates: C:\Users\%Username%\Documents\Custom Office Templates

Excel 2007/2010’ templates: C:\Users\%username%\AppData\Roaming\Microsoft\Templates

For the default Excel template which is applied automatically when creating a new workbook, its default save location is as following:

C:\Documents and Settings\%username%\Application Data\Microsoft\Excel\XLSTART

One click to open folder which contains active workbook with this workbook selected

To quickly open the folder/directory containing current workbook, and have current workbook selected in the opening folder, please try Kutools for Excel’s Open Containing Folder utility. Full Feature Free Trial 30-day!
ad open containing folder 1

Change the default save location of Excel 2013’s templates

Some users may think it’s too difficult to remember the default save location of personal Excel templates. Actually, Excel 2013 supports users to change the default save location of Excel templates as following steps:

1. Click the File > Options.

2. In the opening Excel Options dialog box, click the Save in the left bar, and enter or paste your custom save location into the Default personal templates location box.
doc template default save location 1

3. Click the OK button.

Then the default personal Excel templates’ save location is changed to your custom location.

Change the default save location of Excel 2007/2010’s templates

To change the default save location of Excel 2007/2010’s personal templates, you can do as following:

1. Open Microsoft Word Options dialog box:

  1. In Word 2010, click the File > Options;
  2. In Word 2007, click the Office Button > Word Options.

2. In the opening Word Options dialog box, click the Advanced in the left bar, and then click the File Locations button in the General section.
doc template default save location 2

3. In the coming File Locations dialog box, click to select the User templates in the File types box, and click the Modify button.
doc template default save location 3

4. Now you get into the Modify Location dialog box, find out and select a folder, and then click the OK Button.
doc template default save location 4

5. Click two OK buttons to close the File Locations dialog box and Word Options dialog box.

Related articles:

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (2)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Please can you underline or place in bold "Microsoft Word" on the Step 1 line of : "Change The Default Save Location Of Excel 2007/2010’S Templates"

Because it realy not natural to go in the options of Word to solve a problem of Excel; And the same menu exist on Excel so I had pass a little time to find where I'd made a mistake.

But I say to you a good thanks for a tric I was looking for a long time ago in France and didn't found anything, so thanks agane.
This comment was minimized by the moderator on the site
Hi Gilles,
If you are operating the second method, it does not need to open Microsoft Word at all. Just launch Microsoft Excel, and then click File > Options to open the Excel options dialog box, and then click Save in the left bar.
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations