Forum Discussion
Bug in Excel Online
If your list is dynamic in the first place--if there's a reasonable possibility that you'll be adding more--it might work better if your Data Validation was based on a list held in a set of rows (a Table) on a separate tab in the workbook. As a general practice, when I'm creating a workbook, I almost always create a separate tab called "tables" for use in VLOOKUP tables or in Data Validation. If you assign a name to the table, then you can even add items without changing the reference in your Data Validation window.
If your list is dynamic in the first place--if there's a reasonable possibility that you'll be adding more--it might work better if your Data Validation was based on a list held in a set of rows (a Table) on a separate tab in the workbook. As a general practice, when I'm creating a workbook, I almost always create a separate tab called "tables" for use in VLOOKUP tables or in Data Validation. If you assign a name to the table, then you can even add items without changing the reference in your Data Validation window.
- Well, it's a counter-measure, I suppose. I'll try to make that into a routine to avoid that happening, Thank you!
