Karen,

You can delete them all with a macro

Sub DeleteNames()
For Each n In ActiveWorkbook.Names
n.Delete
Next
End Sub

Mike

"Karen" wrote:

Using MS excel 2003, upon creating a worksheet, hundreds of define names are
automatically embedded in the file. I am not sure where these have come
from. This increases the file size at times 2-4 MB. I can delete these
names, either manually which is time consuming or I have heard of a product
that allows multiple deletions. Regardless when I delete these names the
file size is reduced, but I would prefer to not have these names
automatically embed in the file in the first place. Is there a way to stop
these names from embedding?