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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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