Define Names Embedded in worksheet

[Karen]

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?

 

[Mike H]

Karen,

You can delete them all with a macro

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

Mike

 

[Don Guillett]

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

 

[ShaneDevenshire]

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.

 

[Jim Rech]

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

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