Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

File format for Excel templates 1

Status
Not open for further replies.
Nelviticus

Nelviticus

Programmer
Sep 9, 2003
1,819
GB
We use Excel 2007. One of our users has created a template to put in our shared workgroup templates area, but because it's a huge file they've saved it in the .xlsb format to make it smaller. The .xlsb format is not an Excel template format.

I've done some experimenting and if you put a non-template file - such as .xls, .xlsb, .xlsm or .xlsx - in your templates folder, Excel treats it like a template. It appears in the 'New' dialog box under the 'My templates' item (which is where users find our workgroup templates) and it seems to behave properly if you create a new document based on it, i.e. Excel creates a new document rather than opening it in shared mode.

So my question is this: is there any down-side to using a non-template file format as a template?

Thanks

Nelviticus
 
Sort by date Sort by votes
Both Word and Excel have a "Create New from Existing" capability, which does what it says on the tin. This creates a new document/workbook by copying the existing one, which is not the same as creating a new document based on a template. The big difference is that the VB Project is included in the new document/workbook created this way. There are other differences in Word, I'm not sure about Excel, which uses Templates slightly differently.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website
 
Upvote 0 Downvote
If you put any format of Excel file in your templates directory (local or workgroup) then use Office/New/My templates, Excel will create a new document from it without you having to specifically choose 'Create New from Existing'.

As you've pointed out Tony, the difference between template and non-template files in this instance is that if there's any VB code present, the template ones will strip this out (after executing any AutoNew code).

Thanks, I understand it now.

Nelviticus
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Force Data Entry Format in Excel
Replies
10
Views
248
combo
combo
techie131
  • Locked
  • Question
Excel Date format
2
Replies
20
Views
398
SkipVought
S
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
324
SkipVought
S
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
317
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
316
combo
combo

Part and Inventory Search

Sponsor

Back
Top