Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

excel 2010 save as default template & other template issues

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
orerockon
Asked:
orerockon
  • 3
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
Book.xltx is the default for new workbooks if you use Ctrl+N (or any method other than File-New-Blank workbook).
0
 
rspahitzCommented:
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
 
orerockonAuthor Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Rory ArchibaldCommented:
The template should be in one of your XLSTART folders.
0
 
rspahitzCommented:
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
 
rspahitzCommented:
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
 
Rory ArchibaldCommented:
There is no book.xltx template unless you create one.
0
 
orerockonAuthor Commented:
Thanks all, I never did resolve this, but thatnks for the suggestions.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now