Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Name Conflict Dialog Box???
Excel 2000 ... I have a WorkBook that when I try to copy
one of the TabSheets (any of the 3 TabSheets) I get a Pop- up containing the following (very annoying) message. ************************************************** ******** "A formula or sheet you want to move or copy contains the name 'My_Name' which already exsist 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 in the formula or worksheet, Click No, and enter a new name in the Name Conflict Dialog Box." ************************************************** ******** How do I stop this??? And what did I do to cause this in the 1st place ... as I do not recall having this issue on any of my other spread sheets ... Thanks ... Kha. |
#2
|
|||
|
|||
Hi
goto 'Insert - Name - Define' and check what names you have defined for this workbook/worksheet "Ken" wrote: Excel 2000 ... I have a WorkBook that when I try to copy one of the TabSheets (any of the 3 TabSheets) I get a Pop- up containing the following (very annoying) message. ************************************************** ******** "A formula or sheet you want to move or copy contains the name 'My_Name' which already exsist 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 in the formula or worksheet, Click No, and enter a new name in the Name Conflict Dialog Box." ************************************************** ******** How do I stop this??? And what did I do to cause this in the 1st place ... as I do not recall having this issue on any of my other spread sheets ... Thanks ... Kha. |
#3
|
|||
|
|||
Good morning Frank ...
Following your instructions there were no names listed in my old WorkBook. However, I did get around issue ... instead of copying the TabSheet (in same WorkBook) ... I did a copy/paste of TabSheet contents into a New WorkBook ... then I performed a copy TabSheet in the New WorkBook & all worked fine (no pop-ups with Name Conflict issues). Above said ... I renamed new WorkBook same name as old WorkBook & did a replace existing WorkBook. Now all appears to be fine. I have no clue what occurred in my old WorkBook??? Thanks Frank ... Kha -----Original Message----- Hi goto 'Insert - Name - Define' and check what names you have defined for this workbook/worksheet "Ken" wrote: Excel 2000 ... I have a WorkBook that when I try to copy one of the TabSheets (any of the 3 TabSheets) I get a Pop- up containing the following (very annoying) message. ************************************************** ******** "A formula or sheet you want to move or copy contains the name 'My_Name' which already exsist 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 in the formula or worksheet, Click No, and enter a new name in the Name Conflict Dialog Box." ************************************************** ******** How do I stop this??? And what did I do to cause this in the 1st place ... as I do not recall having this issue on any of my other spread sheets ... Thanks ... Kha. . |
#4
|
|||
|
|||
Maybe the name was hidden -- there are a couple of reasons that could happen.
If you're working with names, 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 If you have the old workbook, you might see what happened and why. And if you don't, get a copy anyway. It's a very useful utility if you work with any names. Ken wrote: Good morning Frank ... Following your instructions there were no names listed in my old WorkBook. However, I did get around issue ... instead of copying the TabSheet (in same WorkBook) ... I did a copy/paste of TabSheet contents into a New WorkBook ... then I performed a copy TabSheet in the New WorkBook & all worked fine (no pop-ups with Name Conflict issues). Above said ... I renamed new WorkBook same name as old WorkBook & did a replace existing WorkBook. Now all appears to be fine. I have no clue what occurred in my old WorkBook??? Thanks Frank ... Kha -----Original Message----- Hi goto 'Insert - Name - Define' and check what names you have defined for this workbook/worksheet "Ken" wrote: Excel 2000 ... I have a WorkBook that when I try to copy one of the TabSheets (any of the 3 TabSheets) I get a Pop- up containing the following (very annoying) message. ************************************************** ******** "A formula or sheet you want to move or copy contains the name 'My_Name' which already exsist 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 in the formula or worksheet, Click No, and enter a new name in the Name Conflict Dialog Box." ************************************************** ******** How do I stop this??? And what did I do to cause this in the 1st place ... as I do not recall having this issue on any of my other spread sheets ... Thanks ... Kha. . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable Query Refresh warning dialog box in Excel 2003 | Excel Discussion (Misc queries) | |||
How can I change the size of dialog boxes? | Excel Discussion (Misc queries) |