Forum Discussion
.xlsb file crashes when I use offset, table[#data] and table[#headers] to create dynamic drop downs
Hi, I have been creating dynamic drop downs by assigning a dynamic name range using offset and the table syntax against two tables and the file corrupts every time when the second dynamic drop do...
Why the dynamic range name, tables make names pointing to their columns dynamic without having to use any functions in the name.
JKPieterse Because the table of an uneven height (column 1 having data down 5 rows and column 2 having data down 7 as an example) will give you 2 empty cells in when you assign column 1 of the table in your drop down.
