copy excel workbook to new workbook without data
 

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?

copy excel workbook to new workbook without data
 

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

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

copy excel workbook to new workbook without data
 

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

copy excel workbook to new workbook without data
 

Sure,

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

Beege


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