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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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,429
Messages
6,119,433
Members
448,897
Latest member
ksjohnson1970

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