Help with Template Creation: Basic Question

[mollys]

Hi Board -
You've all been extremely helpful in the past so I have high hopes for this one.

At work, I do a lot of spreadsheet analysis. Currently, we have a workbook that has a ton of formulas/arrays/etc. and when we need to create a new one we just resave and old one and over-write the data.
However, I was hoping to create a template that would save all the formulas and all the arrays in a blank workbook that can be used over and over.
Is this possible through template creation? Is there a simple way to do this?

Thanks so much for your help!!
Molly

 

[Dryver14]

in excel 2007 select excel options
then save
then you have a save file in this format option box
select save as template or macro enabled template if that is what you have

 

[Dryver14]

the other option of course is just to have a master file then save as with each new creation