What is an excel template?

  • Thread starter Thread starter Guest
  • Start date Start date
As an example, you may design an empty inovice in a spreadsheet. You design
it, get all the formulae working, get it to autonumber on opening, or every
time you print an invoice, and to clean out the info - transfer to a detail
listing of invoices, or save the invoice as another name, etc. You want to
use this to do your inovicing,
If you save this as an XLA, you will always use this sheet to do invoicing,
but you will never save it as an invoice, and botch up all the work you have
done
 
An XL template is a workbook which is stored in a particular file (folder -
location), where a user automatically opens a *copy* of the WB, preserving
the original from accidental and/or unintentional revisions.

Usually accessible from the:
<File> <New> folder, which may contain *any* number of different
'templates', where a click on the template name *automatically* opens a
*copy* of the template.

After making revisions (filling blanks - completing calcs) to this 'template
copy', the user performs a "Save As", and relabels the copy with a new,
pertinent name and/or file (folder) location.


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


What is an excel template and what makes it different from normal workbooks?
 
Really *doesn't* even have to be that (.xlt).

..xls works just as well when placed in the proper locations.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


Kassie

It's an *.xlt not *.xla (which is an add-in)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
The good thing if saving as *.xlt is that it will automatically save it in
the templates folder

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
*IF* that's where you want it to be saved.
That automatically puts it into the exclusive XL templates folder

Maybe you'll want it to go into the Office templates folder.


BUT ... I guess since we're in an XL group, that's more likely the case.<bg>
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

The good thing if saving as *.xlt is that it will automatically save it in
the templates folder

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
 
Back
Top