I have a large workbook in which I have a saved worksheet that is used to
make other identical worksheets. The saved worksheet is working properly in
regards to formulas, leaving cells blank, etc. However when I copy this
worksheet to another worksheet in the workbook one column which uses the SUM
function changes from a blank cell to one containing a 0 if there is no data
in any of the fields that it is summing. I cant have this.

I have tried clear formatting only with the result that the 0 just reduces
in size - as does anything in the column that has real results.

Thanks