copy excel workbook to new workbook without data

[Omnitool]

Have an excel workbook with multiple work sheets, need to copy all formulas,
styles, layouts, etc. to new workbook without the data in the original
workbook?

Do I need to create the work sheets and names prior to copying?

[Bob Umlas]

save the workbook with a new name, then clear all constants in all sheets
and you have your copy.

"Omnitool" <[email protected]> wrote in message
news:[email protected]...
> Have an excel workbook with multiple work sheets, need to copy all
> formulas,
> styles, layouts, etc. to new workbook without the data in the original
> workbook?
>
> Do I need to create the work sheets and names prior to copying?

[Omnitool]

Can I clear the constants collectively in each sheet with out effecting the
formulas or style?

"Bob Umlas" wrote:

> save the workbook with a new name, then clear all constants in all sheets
> and you have your copy.
>
> "Omnitool" <[email protected]> wrote in message
> news:[email protected]...
> > Have an excel workbook with multiple work sheets, need to copy all
> > formulas,
> > styles, layouts, etc. to new workbook without the data in the original
> > workbook?
> >
> > Do I need to create the work sheets and names prior to copying?
>
>
>

[Beege]

Sure,

Edit/Go To/ Special/Constants/OK
Hit delete

Beege


"Omnitool" <[email protected]> wrote in message
news:[email protected]...
> Can I clear the constants collectively in each sheet with out effecting
> the
> formulas or style?
>
> "Bob Umlas" wrote:
>
>> save the workbook with a new name, then clear all constants in all sheets
>> and you have your copy.
>>
>> "Omnitool" <[email protected]> wrote in message
>> news:[email protected]...
>> > Have an excel workbook with multiple work sheets, need to copy all
>> > formulas,
>> > styles, layouts, etc. to new workbook without the data in the original
>> > workbook?
>> >
>> > Do I need to create the work sheets and names prior to copying?
>>
>>
>>