?
Solved

excel 2010 save as default template & other template issues

Posted on 2011-09-20
8
Medium Priority
?
449 Views
Last Modified: 2012-05-12
I don't see an answer to this but I may not be searching for the right terms. I want to save a file opened in Excel to the default template, Book.xltx (see below). On my system that is (weirdly) located in "Word Templates" which I suppose is a default I set in Word 2010. For example, I open a csv file and save as the same filename in xlsx format. How can I automatically apply the default sheet template to the csv when I open it or when I save it?

The Book.xltx template works when I select it from the My Templates menu when I create a new workbook but isn't the default for a blank workbook (another problem I suppose). It names it Book.xltx1 which is also stupid, can I get it to name the new workbook Book.xlsx or similar?
0
Comment
Question by:orerockon
  • 3
  • 3
  • 2
8 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36572772
Book.xltx is the default for new workbooks if you use Ctrl+N (or any method other than File-New-Blank workbook).
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 36574482
Are you asking how to make a new default template, or how to apply a template to a CSV file?

In the first case, simple create your template as a regular spreadsheet then, as rory indicated, save as Book.xltx in the default templates folder.

In the case of applying that to another file, I don't think there is a direct way to do that.  A template is a one-time set-up file and is not like HTML stylesheets that will apply to existing files every time you update the stylesheet.
So the only practical way to work this is to open a new spreadsheet based on the template you want (such as the default) then import the CSV file into a new sheet and reference the pieces as needed from that sheet.
You could also write some VBA to handle all of this, but it's not a trivial task so it is more subject to problems.
0
 

Author Comment

by:orerockon
ID: 36575811
rorya: ctrl-N doesn't use the Book.xltx template in C:\Program Files\Microsoft Office\Office14\1033. Neither does it use Sheet.xltx when I rename Book.xltx and save it as Sheet.xltx. Also file-new I still have to click my templates & select Book.xltx to get it to work.

rspahitz: Good advice, however where is the default templates folder? I only find an xltx file extension in C:\Program Files\Microsoft Office\Office14\1033 in Win 7 search. And a bunch of junk in Office 2010/Templates.

0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
LVL 85

Expert Comment

by:Rory Archibald
ID: 36576288
The template should be in one of your XLSTART folders.
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 36576717
I found that the best way to find the templates folder is to try to save something with type templates.  On the save-as window, as soon as you pick Excel Templates in the bottom drop-down list, it changes to the templates folder...copy the path then cancel the save.

In my win7 setup it's here:

C:\Users\{current user}\AppData\Roaming\Microsoft\Templates
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 36576768
Looking further, that might be only for custom templates.
I also see this for the macros workbook:

C:\Users\{current user}\AppData\Roaming\Microsoft\Excel\XLSTART

Since I don't see Book.xltx, I'm not sure if it's because I haven't customized it (and it uses a default blank set) or because it's in a different location.  I'll search and see if I locate it.
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 36576785
There is no book.xltx template unless you create one.
0
 

Author Comment

by:orerockon
ID: 36956832
Thanks all, I never did resolve this, but thatnks for the suggestions.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

599 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