I have an Excell file with many sheets and alot of formula that a collegue
that has now left created. Data has been entered into these sheets. What I
want to be able to do is copy all the sheets and the formula but not the data
so what I get is a fresh template of the original spreadsheet.

I hope you can help and I thank you in advance.

Ross

**CAUTION **
Try this on a test workbook, not your actual file until you believe this
approach
will work for you... It might not..
On Each worksheet (one-by-one) you can
Select the entire sheet (either Cont+A or click inside the blank box to left
of Column "A" and Over the Row "1" ) either way the sheet should turn blue.

At the menu, click on Edit, GoTo... Click on Special... click next to
Constants.
As you do ONLY and ALL Cells that Are not Formulas will be highlited.
Press the Delete Key. Your formulas remain, but do not display ##'s due to
the data (constants) having been removed. ONLY after being satified - SAVE
the
file as your Template.

Jim


"Ross" wrote:

I have an Excell file with many sheets and alot of formula that a collegue
that has now left created. Data has been entered into these sheets. What I
want to be able to do is copy all the sheets and the formula but not the data
so what I get is a fresh template of the original spreadsheet.

I hope you can help and I thank you in advance.

Ross