I constantly get this error in Excel: A formula or sheet you want to move or copy containts the name ‘naziv’ 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 in the formula or worksheet, click No, and enter a new name in the Name Conflict dialog box.
This is very important, because it needs to be copied everyday, but I can’t change the destination sheet, because it has to be named like this…
Screenshot
I tried this: “This error generally arises when there are some erroneous names in the worksheet. Press Ctrl+F3 (the Excel name manager box will show up). On the right hand side there will be a filter button – select “Names with error” and once all of them show up, delete the erroneous names.” – but still the same error appears.
Milan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1