I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.

Create a true Template with the formatting and formulas but no data.

Save asFile TypeExcel Template(*.xlt)

Your users open that template file and a copy is created for them to fill in
data.

They save that copy and your original template is not touched.


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 08:29:56 -0700, JDV
wrote:

I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.

Thank you for responding. So in essence I have to retype my formulas after
removing the data so that it ca be saved as such?

"Gord Dibben" wrote:

Create a true Template with the formatting and formulas but no data.

Save asFile TypeExcel Template(*.xlt)

Your users open that template file and a copy is created for them to fill in
data.

They save that copy and your original template is not touched.


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 08:29:56 -0700, JDV
wrote:

I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.

Gord said, in the post to which you were replying:
"Create a true Template with the formatting and formulas but no data".

He didn't say delete the formulas; he only wanted you to delete the data.
--
David Biddulph

"JDV" wrote in message
...
Thank you for responding. So in essence I have to retype my formulas
after
removing the data so that it ca be saved as such?

"Gord Dibben" wrote:

Create a true Template with the formatting and formulas but no data.

Save asFile TypeExcel Template(*.xlt)

Your users open that template file and a copy is created for them to fill
in
data.

They save that copy and your original template is not touched.


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 08:29:56 -0700, JDV
wrote:

I have created a workbook containing two sheets with various formulas
for my
organization. I would like to save this as a template to use for each
group
however when I delete the current data in order to replace with
different
data my formulas are lost. Is there any way to save the formatting and
the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but
not
the individual cell data.

Not necessary to re-type formulas from the current workbook/sheet

Hit F5 and SpecialConstants and OK...........if you have titles or text you
want to retain, uncheck that option button before OK'ing

EditClear Contents.

This will leave the formulas in place.

Now save as a Template.


Gord

On Tue, 29 Jul 2008 09:05:03 -0700, JDV
wrote:

Thank you for responding. So in essence I have to retype my formulas after
removing the data so that it ca be saved as such?

"Gord Dibben" wrote:

Create a true Template with the formatting and formulas but no data.

Save asFile TypeExcel Template(*.xlt)

Your users open that template file and a copy is created for them to fill in
data.

They save that copy and your original template is not touched.


Gord Dibben MS Excel MVP

On Tue, 29 Jul 2008 08:29:56 -0700, JDV
wrote:

I have created a workbook containing two sheets with various formulas for my
organization. I would like to save this as a template to use for each group
however when I delete the current data in order to replace with different
data my formulas are lost. Is there any way to save the formatting and the
formulas of a workbook/worksheet without saving the current data. In
essence, I want to preserve the colors, fonts, set-up, formulas etc but not
the individual cell data.