Stop Adding Defined Names When Pasting Formulas or Adding Tokens from Clipboard
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.
peAk Education
Grow Your Knowledge
Follow along with our instructors as they take you on a journey to build your foundational knowledge of Microvellum.
Follow us on:
ERP for Millwork Shops
Discover how Microvellum and INNERGY streamline operations for cabinet shops and millwork manufacturers.