Forum Discussion
Solving Name conflict in excel
How do you solve name conflict in excel worksheet when copying worksheets?
Depends on their use I guess. Whether or not you want to keep the name definition of your target workbook when pasting there will also depend on the structure of both source and target. This is one of the drawbacks of copying formulas from one workbook to another where both workbooks contain range names. It can be quite a challenge to figure out which range names should be kept. My Name Manager available for free through https://jkp-ads.com/officemarketplacenm-en.asp shows all range names in a file, including the hidden ones.
Thanks i did get the results as shown, unfortunately i wasn't able to move the worksheet to the new workbook. Unfortunately no other excel operation can go on unless i close excel using the task manager and stop all excel tasks running, a solution would be welcome.
You could simply click the Yes to All button I showed above. You can get back to that dialog by cancelling the one you displayed in your first message.
- Tried that and didn't work had to repeat the whole stuff again by ending excel application. it only works when i move to a blank/new book not to the second workbook...thanks anyways
- I would advise you to check Name Manager (from the Formula tab of the ribbon) for both files. See if all range names are expected to be in that file or not.
Thanks i will, should they be the same or not to ensure no conflict.
