The Apply Names command loses parts of formulas and in certain cases Excel will crash.This bug is in Excel 2010 and 2013, not in Excel 2007 or 2003.To reproduce this, follow these steps. If you wish I can email you a workbook which shows the bug.
Enter 2 in B1 and 3 in B2 Enter =B1 in A4 Enter =B2 in A5 Give $B$1 the name "value_1" Give $B$2 the name "value_2" Enter the formulas below starting in B4, and then click Names > Apply Names and select both names. =B2/B1 =$B$2/$B$1 =$B$2/B1 =B2/$B$1 In B4 The expected result is =value_2/value_1, what you get is just =value_2 Furthermore, if you UNcheck "Ignore relative/absolute" you get for =B2/B1 unchanged, fine =$B$2/$B$1 becomes =value_2/value_1, fine =B2/$B$1 gives an error "Formula is too long. Formulas may not exceed 8192 characters" (see also http://www.excelforum.com/excel-general/738331-fomula-too-long-when-applying-names-to-ranges.html) and =$B$2/B1 gives "Microsoft Excel has stopped working" It has previously been reported to Microsoft but no fix was announced: Excel 2010 truncates formulas when applying names http://answers.microsoft.com/en-us/office/forum/office_2010-excel/excel-2010-truncates-formulas-when-applying-names/418d6864-8fb1-4845-9686-eea6331e852f?msgId=9695513e-4615-498c-a5c7-31e1d0faa134 Excel 2010 truncates formulas when applying names No fix has been reported, and it's been known for two years now.