Excel templates

I want to save a workbook as a template. What directory does Microsoft use to keep user created Excel templates?
Frank FreeseAsked:
Who is Participating?
Patrick MatthewsConnect With a Mentor Commented:
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"
GeisrudConnect With a Mentor Systems 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?
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.

All Courses

From novice to tech pro — start learning today.