Solved

Excel 2010 Template location

Posted on 2010-08-26
8
13,372 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: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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
.Range Set 25 77
Excel. How to get via VBA the last used row in a named dynamic range 10 37
Formula Help 3 22
vba delete dups is not working 35 14
Both MMF (multi-mode fiber) and SMF (single-mode fiber) are types of optical fiber that can aid in communication applications. These thin strands of silica or glass will allow communication to occur between devices. The transmission of light between…
My experience with Windows 10 over a one year period and suggestions for smooth operation
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

772 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