simple template question

G

Guest

Guest
Guys,

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

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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)
 
Upvote 0

Forum statistics

Threads
1,214,812
Messages
6,121,702
Members
449,048
Latest member
81jamesacct

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top