May 09 2019 05:45 PM
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 down name range is set. Once the file is closed I cannot open it again with Excel 2016 prompting the file is corrupt.
Keen for some guidance whether it's something I am not doing right or it's an Excel issue.
Thank you.
May 14 2019 10:22 PM
May 14 2019 11:55 PM
@Jan Karel Pieterse 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.
May 15 2019 12:12 AM