Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

excel 2010 save as default template & other template issues

Posted on 2011-09-20
8
Medium Priority
?
439 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
[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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

670 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