Forum Discussion
Solving Name conflict in excel
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 will, should they be the same or not to ensure no conflict.
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.