Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Fix the 'Apply Names' bug that corrupts formulas or crashes Excel

As already reported in

http://answers.microsoft.com/en-us/office/forum/office_2013_release-excel/when-will-the-apply-names-bug-in-excel-be-fixed/0eb23d54-fbf0-4c64-8bad-cf52bc32547f?auth=1

The Apply Names command loses parts of formulas and in certain cases Excel will crash.

This bug is in Excel 2010 and 2013 and 2016, not in Excel 2007 or 2003.
To reproduce this, follow these steps.

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"

1 vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Patrick O'Beirne shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  Dan Battagin [MS XL] responded  · 

Hi,

I just read through the answers.microsoft.com post that you linked to, and it appears that this is fixed in Excel 2016 build 16.0.6568.2025.

Also, we’d like to try to keep this uservoice site for new feature ideas, rather than for bug fixes (which answers.microsoft.com is targeted at.)

Cheers,
Dan [MS]

1 comment

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base