Solved

Excel 2010 Template location

Posted on 2010-08-26
8
13,590 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Outlook Free & Paid Tools
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

839 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