What is an excel template and what makes it different from normal workbooks?

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


"cssniper" wrote:

What is an excel template and what makes it different from normal workbooks?

Kassie

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kassie" wrote in message
...
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


"cssniper" wrote:

What is an excel template and what makes it different from normal
workbooks?

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!
================================================== ===


"cssniper" wrote in message
...
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 !
----------------------------------------------------------------------------
-------------------


"Nick Hodge" wrote in message
...
Kassie

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kassie" wrote in message
...
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


"cssniper" wrote:

What is an excel template and what makes it different from normal
workbooks?

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


"RagDyeR" wrote in message
...
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 !
----------------------------------------------------------------------------
-------------------


"Nick Hodge" wrote in message
...
Kassie

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kassie" wrote in message
...
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


"cssniper" wrote:

What is an excel template and what makes it different from normal
workbooks?

*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 !
----------------------------------------------------------------------------
-------------------

"Peo Sjoblom" wrote in message
...
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


"RagDyeR" wrote in message
...
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 !
--------------------------------------------------------------------------
--
-------------------


"Nick Hodge" wrote in message
...
Kassie

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kassie" wrote in message
...
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


"cssniper" wrote:

What is an excel template and what makes it different from normal
workbooks?

Thanks Nick, don't know where I dug that one out!

"Nick Hodge" wrote:

Kassie

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"kassie" wrote in message
...
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


"cssniper" wrote:

What is an excel template and what makes it different from normal
workbooks?