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?

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?

Are you saying that when you delete them, they come back?? If so, there must
be a macro doing it. If desired, send you file to my addy below and I'll
take a look. You can use this Umlas macro to delete ALL
Sub DeleteAllNames_Umlas()
ExecuteExcel4Macro "SUM(DELETE.NAME(NAMES()))"
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

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

Hi,

Here is another possibility - they may be part of the default workbook. To
talk care of that
Choose file open and navigate to the C:\Program Files\Microsoft
Office\Office #\XLStart folder and delete any files in that folder. by
Office# I mean your version of Excel might be 10, 11, 12.


--
Thanks,
Shane Devenshire


"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?

Just delete them all huh, Shane? I have a handnail. Should I chop off the
finger or go for the whole hand?<g

--
Jim
"ShaneDevenshire" wrote in
message ...
| Hi,
|
| Here is another possibility - they may be part of the default workbook.
To
| talk care of that
| Choose file open and navigate to the C:\Program Files\Microsoft
| Office\Office #\XLStart folder and delete any files in that folder. by
| Office# I mean your version of Excel might be 10, 11, 12.
|
|
| --
| Thanks,
| Shane Devenshire
|
|
| "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?