Feb 18 2020 01:03 AM - edited Feb 18 2020 01:05 AM
@stanoh I suspect that you have copied a series of cells from workbook 1, worksheet A to workbook 2 worksheet B where both workbooks contain the same range name. When that happens, prior to the dialog you showed you get a dialog like the attached one on which you appear to have clicked "No".
That means that you want to KEEP the now duplicated range name, therefore Excel prompts for a new name as two global range names cannot be the same.
Feb 18 2020 05:21 AM
Feb 18 2020 05:34 AM
Feb 18 2020 05:44 AM
Feb 18 2020 05:50 AM
Feb 18 2020 05:57 AM
Thanks i will, should they be the same or not to ensure no conflict.
Feb 18 2020 06:03 AM - edited Feb 19 2020 04:41 AM
SolutionDepends 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.
Feb 18 2020 06:03 AM - edited Feb 19 2020 04:41 AM
SolutionDepends 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.