Forum Discussion
VCh3n
May 09, 2019Copper Contributor
.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...
Twifoo
May 15, 2019Silver Contributor
If that is so, convert your table to a range (Right-click,b,v). Also, use INDEX instead of the volatile OFFSET.