Cyberdude
12-23-2005, 09:08 PM
I have two nearly identical workbooks and they each contain mostly the same Defined Names. If I copy a worksheet from Workbook A to Workbook B, then many of the defined names in Workbook A will be defined for the copied worksheet in Workbook B as an override to identically defined names in Workbook B. I cannot use the copied worksheet until I manually go through and delete all the override defined names that have been defined for it. I?ve been doing this annoying task once a month for three worksheets for literally years.
I?ve never really understood what dictates that a particular defined name has an override name defined for it. A lot of the names occur in sequences of 12 (Security1, Security2, Security3,?), but not necessarily all the names in a sequence are overridden (but usually they all are). I have a hazy idea of why this is done by Excel, but when you have several hundred names to remove each month, it gets to be a dreaded chore.
Is there a way to prevent Excel from making the override definitions when a sheet is copied? (Groan)
I?ve never really understood what dictates that a particular defined name has an override name defined for it. A lot of the names occur in sequences of 12 (Security1, Security2, Security3,?), but not necessarily all the names in a sequence are overridden (but usually they all are). I have a hazy idea of why this is done by Excel, but when you have several hundred names to remove each month, it gets to be a dreaded chore.
Is there a way to prevent Excel from making the override definitions when a sheet is copied? (Groan)