Solved

Excel 2010 Template location

Posted on 2010-08-26
8
12,890 Views
Last Modified: 2012-05-10
Anyone know where the default template location for Excel 2010 is (why is it so difficult to find!)
I have created a custom template and want it to appear in the users template list
0
Comment
Question by:KCTS
8 Comments
 
LVL 17

Accepted Solution

by:
calacuccia earned 250 total points
ID: 33536803
It appears to be common with Word (what an idea)

>Open a document in Word...........yes, Word........... then go to
>Tools>Options>File Locations>User Templates>Modify.
>
>This location is common with Excel.
0
 
LVL 50

Expert Comment

by:teylyn
ID: 33536859
It also depends on the operating system. In Windows XP, the default path for the 2010 templates is

C:\Documents and Settings\<username>\Application Data\Microsoft\Templates

This may be different in Vista or Windows 7

cheers, teylyn
0
 
LVL 50

Assisted Solution

by:teylyn
teylyn earned 250 total points
ID: 33536884
In Word 2010 you find the file locations via

File - Options - Advanced - General section (almost at the bottom) - File locations button. This will pop up the list of file locations and you can click Modify to change it.

cheers, teylyn
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Expert Comment

by:ilyasubkhankulov
ID: 33536943
Excel 2007 looks into C:\users\YOURUSERNAMEHERE\AppData\Roaming\Microsoft\Templates for excel templates in windows 7
0
 
LVL 70

Author Comment

by:KCTS
ID: 33536970
I'm using Win7 and Office2010 - it does indeed appear that the location of ALL templates is determined by the setting in WORD as @teylyn suggests - how intuitive !!
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 33537069
I did suggest exactly the same tihing :-)
0
 
LVL 50

Expert Comment

by:teylyn
ID: 33537828
it was calacuccia who pointed out that the template location for Excel is set in Word.

I just showed the 2010 way of accessing the Modify dialog.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Ever wondered why Windows 8 and 10 don't seem to accept your GPO-based software deployment while Windows 7 does? Read on.
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now