💻 Software

Excel: Update a value in a named range

Fresh7 days ago

Mar 15, 20266477 views

Confidence Score0%

Problem

I've got some cells in an Excel doc populated from a named range (data/validation/list source=MyNamedRange): Here, the A1:A3 range is named Foobar B5:B6 is under data validation with it's source set to 'Foobar' I'd like to be able to update cell's A2 content, from Bar to Quux, and see automatically…

Unverified for your environment

Select your OS to check compatibility.

Your OS

OS version

Product version

1 Fix

Canonical Fix

Unverified Fix

New Fix – Awaiting Verification

Fix for: Excel: Update a value in a named range

Low Risk

This seems dangerous, but I can't see any problem with it. Basically if you change anything in Foobar, it searches every cell on the sheet that has Data Validation. If the DV points to Foobar and the value isn't in the list, then it must have been t…

Awaiting Verification

Be the first to verify this fix

Excel: Update a value in a named range

Problem

1 Fix

Fix for: Excel: Update a value in a named range

Environment