Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: simple template question

  1. #1
    Guest

    Default

    Guys,

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

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •