Error message with copying sheet to another workbook

[Chew]

I always encounter an error message when i copy a sheet from one workbook to
another workbook.


The error message is as below:

================
A formula or sheet you want to move or copy contains the name
'____123graph_A', which already exists on the destination worksheet. Do you
want to use this version of the name?
- to use the name as defined in the destination sheet, click Yes
- to rename the range referred to the formula or worksheet, click No, and
enter a new name in the Name Conflict dialog box.
================

I have tried to click No and enter a new Name, but afterwards i could not
find the new Name i gave too.

For you info, some of the workbooks were converted from Lotus 123 about 10
years ago. Probably that was why the Name always appears as
"______123graph_X" where X can be A, B, C etc.

How to get rid of this message?

Best regards,

Chew

 

[Dave Peterson]

The first thing I'd do is to try to find out what that name pointed to and if it
was used. Then if I didn't need it, I'd delete it.

I'd get 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 make this kind of detective work much easier.

 

[Chew]

No, the name is neither used and neither can be found in Insert>Name>Define
window. So it cant be deleted as it is not there.
Thats funny.

 

[Dave Peterson]

Some names can be hidden from the user.

Did you try the name manager addin? It has the ability to show those hidden
names.

 

[Chew]

I do not know that Names can be hidden in Excel. Will try that add-in. tq.
But is it possible to manually hidden the Names without using that add in?

Regards,

 

[Dave Peterson]

You can use a macro to hide or unhide names. But the addin offers so many other
features, it's worth the download and installation time.

I do not know that Names can be hidden in Excel. Will try that add-in. tq.
But is it possible to manually hidden the Names without using that add in?

Regards,