simple template question

Mar 12th, 2002, 07:26 AM

Guys,

What exactly does saving an excel file as a template (.xlt) do as opposed to the regular (.xls)? Advantages, differences, etc.? Thanks!

lenze · Mar 12th, 2002, 07:43 AM

When a file is saved as a template, it becomes available for users to create NEW Workbooks based on the template, while maintaining the integrety of the original. This is useful in many applications. For instance, a form that one fills out on a regular basis can be pre-populated with data that does not change. Placing a template on a shared drive is an excellent way to distribute a file and beause there is only one original, making changes is easier. Probably one the the most useful parts of a template is the ability to attach it to an database file to facilitate data entry, especially when more than one person is entering information.(See Template Wizard with Data Tracking)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 07:26 AM	#1
Guest Posts: n/a	Guys, What exactly does saving an excel file as a template (.xlt) do as opposed to the regular (.xls)? Advantages, differences, etc.? Thanks!

Mar 12th, 2002, 07:43 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	When a file is saved as a template, it becomes available for users to create NEW Workbooks based on the template, while maintaining the integrety of the original. This is useful in many applications. For instance, a form that one fills out on a regular basis can be pre-populated with data that does not change. Placing a template on a shared drive is an excellent way to distribute a file and beause there is only one original, making changes is easier. Probably one the the most useful parts of a template is the ability to attach it to an database file to facilitate data entry, especially when more than one person is entering information.(See Template Wizard with Data Tracking)