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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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,215,043
Messages
6,122,816
Members
449,095
Latest member
m_smith_solihull

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