Error message with copying sheet to another workbook

  • Thread starter Thread starter Chew
  • Start date Start date
C

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
 
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.
 
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.
 
Some names can be hidden from the user.

Did you try the name manager addin? It has the ability to show those hidden
names.
 
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,
 
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,
Click to expand...
 
Back
Top