• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

Excel templates

I want to save a workbook as a template. What directory does Microsoft use to keep user created Excel templates?
Frank Freese
Frank Freese
  • 2
2 Solutions
GeisrudSystems AdministratorCommented:
By default they save to (Excel 2007+ on Windows 7):
C:\Users\[username]\Documents\Custom Office Templates

It will default there when you change the filetype to an .xltx (template) file.

However, you can save to whichever directory you like by simply changing it like you would any other file.
Frank FreeseAuthor Commented:
What about 2010 Office - Excel - Windows 7?
Patrick MatthewsCommented:
User-created templates should go in your default user template directory.  In Excel 2007 and later, to find this:

1) Click File on the Ribbon in Excel 2010+, or the Office symbol in Excel 2007
2) Click Options
3) Click Trust Center
4) Click Trust Center Settings
5) Click Trusted Locations

Now, in the list of Trusted Locations, find the directory with the description "Excel 20?? default location: User Templates"
Frank FreeseAuthor Commented:
thanks folks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now