Name conflicts

[Peter]

Below email was posted before. I have lost the link that direct me to the
add-in manager that can unhide hidden name.
Can anyone advise me again.

TQ
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,

 

[Bob Phillips]

Jan Karel Pieterse has a utility designed to improve working with defined
names.
It is a free add-in, and you can get it at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)