I'm needing to add some custom machining tokens from our clipboard, but when I do it is automatically appending the defined names into the product/subassembly.
This is very annoying because it creates overlapping defined names, and new defined names in various locations throughout the spreadsheet.
In my particular case, my machine token has been developed with IFERROR statements so that if defined names are not found it references global values. Well, with defined names being automatically appended upon pasting, this completely nullifies this token; and because of the overlapping placement I end up with false positives and values that are completely wrong.
This happens whether I'm adding from the clipboard, OR if I open the clipboard using Workbook Designer and paste directly from one spreadsheet to another.
Appending defined names should never happen.