View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Define Names Embedded in worksheet

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?