Feedback by UserVoice

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

Data validation list sources referring to tables are only dynamic for tables on the same sheet

Data validation still does not support structured references as list sources. Luckily, the non-structured references to table columns update if the column changes size. However, this only occurs if the data validation cell and the table are on the same sheet. This is further incentive, beyond the usual readability issue, for Excel to support structured references in data validation.

You can download a demo file here:
http://www.mediafire.com/view/hrz90a8u7kk456p/Data_Validation_Table_Update.xlsb

Posts related to data validation and structured references:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/9018427-improve-data-validation
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10561302-data-validation-allow-table-references-as-list-s

9 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Kenneth Barber shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Bryon Smedley commented  ·   ·  Flag as inappropriate

    This is quite odd. I prefer to have my validation lists hidden on a separate sheet, but have to use convoluted formula solutions to make them dynamic. I can use a Data Table to make it dynamic, but it can no longer be on the hidden sheet. It would be nice to be able to use structured references for dynamic drop-down lists.

Feedback and Knowledge Base