FG
💻 Software

Putting table name as a reference for the purpose of cell values validation

Fresh5 days ago
Mar 15, 202611693 views
Confidence Score0%
0%

Problem

I want to validate cell values with the help of the simple list. But it turns out that it's difficult to extend this list without necessity of updating validation source range every time new value is added as shown on the picture. My question is: could I put dynamic table reference into the 'source…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Putting table name as a reference for the purpose of cell values validation

Low Risk

As of Excel 2010, you can't directly use structured references as the source list for data validation. However, you CAN define a name for the structured reference, and use this new name instead. For example, if I have a single-column table named tha…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment