I have copied a worksheet from an old workbook. Now whenever I make a copy of
the sheet, I get a statement that a "name" already exists and do I want to
keep the original. Just one thing. There are no named ranges in the workbook;
I have deleted them all. I have even removed all format styles other than the
basic ones. However, I still get the mesage that the name (sometimes with and
sometimes without the wrn extension) exists. This is concerning since I may
give the worksheet to a potential client and the "name" refers to another
entity. I also now have picked up somewhere along the line pornographic
"names", which is really uncool to give to a client. Help!

Excel creates names (usually hidden) when you run certain features. I think
some wrn.* names are created when you use Report Manager. (I've seen them in
other workbooks/worksheets when I never used Report Manager, too.)

I'd get a copy of Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

It'll help you decide what you want to do with the name.

Mpuppy wrote:

I have copied a worksheet from an old workbook. Now whenever I make a copy of
the sheet, I get a statement that a "name" already exists and do I want to
keep the original. Just one thing. There are no named ranges in the workbook;
I have deleted them all. I have even removed all format styles other than the
basic ones. However, I still get the mesage that the name (sometimes with and
sometimes without the wrn extension) exists. This is concerning since I may
give the worksheet to a potential client and the "name" refers to another
entity. I also now have picked up somewhere along the line pornographic
"names", which is really uncool to give to a client. Help!

--

Dave Peterson