💻 Software
Putting table name as a reference for the purpose of cell values validation
Fresh5 days ago
Mar 15, 202611693 viewsConfidence 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