Solved

Excel 2010 Template location

Posted on 2010-08-26
8
13,885 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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:Ingeborg Hawighorst
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:Ingeborg Hawighorst
Ingeborg Hawighorst 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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:Ingeborg Hawighorst
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This article was originally published on Monitis Blog, you can check it  here .   Some years back, I worked as the CTO.  During my tenure, I had a head of IT support reporting to me.  He did his job quite well and had a commendable sense of duty…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

733 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