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
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.
- Close all open Workbooks if any & shut down Excel.
- Restart Excel and then open the workbook.
Ctrl+F3and filter the named ranges on errors.
- Delete all erroneous named ranges.
- Finish with OK.
- Save & close the workbook.
Now when you copy or move sheets, you should not face that error.
- May possible you have few formulas in-
Named Rangescan't be deleted so that better
NAMED RANGESat source Workbook to avoid the duplicates. I think
Renamethem is the best possible solution.
Hope this also work for you.
I had the similar problem, so I'll tell you how I got rid of it. First, click on formulas tab on the ribbon and click on Name Manager>, scroll through the list of defined names and look at what that name refers to. I had one that referred to another workbook, I deleted it, and it fixed the problem. Hope this helps you too!