Unwanted Range Names are Imported

G

gnewbury

I am working with a Workbook to do data analysis. The data which I am
to analyze is presented to me in another Workbook which has many named
ranges. My spreadsheet also has named ranges which are referenced in
my formulas. When maintaining my Workbook, I routinely copy data from
the "outside" Workbook, and then paste it into my "analysis" Workbook
via the clipboard, using PasteSpecial - Values. After I do this, the
list of named ranges in my Workbook include all the names from both my
"analysis" workbook and the "outside" Workbook. There are hundreds of
names, and many of the "outside" names are so similar to those on the
"analysis" Workbook that it becomes very difficult to maintain my
Workbook. I need some suggestions as to why these names are imported,
and how to prevent this from happening.

Many thanks, gnewbury
 
J

Jim Rech

I couldn't duplicate the problem in a simple example using Paste Special
Values. In any case, try opening the workbooks in different instances of
Excel. In this case all you can copy across Excels is "Values", I believe,
so I wouldn't expect the names to follow.
 
G

gnewbury

Thanks for the suggestion Jim.

I have gone through and manually deleted (not the first time I have ha
to do this) all the external range names, so I will try this the nex
time I receive some new data to update my Workbook.

Regards;

G
 
D

Dave Peterson

Are you sure the names weren't there before you started?

And if you're working with names, get Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager.

http://www.jkp-ads.com/Download.htm

You'll be very happy with all the features.
 
Top