Excel: Name already exist in destination

microsoft excelworksheet-function

After cleaning out all the names in the Name Manager list in a worksheet in Excel, I tried moving the sheet all over again and still got the pop-up message of "name already in the destination'. What am I missing please

Best Answer

Long back I've had similar problem and I found the reason was that some worksheets had been moved or copied from other workbooks, which have had named ranges also.

You can try these steps to get rid from the issue.

  1. Close all open Workbooks if any & shut down Excel.
  2. Restart Excel and then open the workbook.
  3. Press Ctrl+F3 and filter the named ranges on errors.
  4. Delete all erroneous named ranges.
  5. Finish with OK.
  6. Save & close the workbook.

Now when you copy or move sheets, you should not face that error.

Edited:

  1. May possible you have few formulas in- tagged with Named Ranges can't be deleted so that better RENAME the NAMED RANGES at source Workbook to avoid the duplicates. I think Rename them is the best possible solution.

Hope this also work for you.

Related Question