Using: Excel 2011 ver. 14.4.7
I'm using a Data Table in Excel 2011. When I try to create a new record by starting to insert data into a cell in the row immediately below the last row of my table (which is supposed to automatically get appended as a new record to my Data Table), some drop-down lists get copied correctly and others don't.
For example, in the attached image, if I entered the year 2014 as a means of starting the new record and hit 'return', the drop-down lists in the columns for Year and Month, get copied correctly from the Data Table, but no drop-down list gets copied for the Day column. I get a blank cell in the newly created cell under the Day column instead of the drop-down list which exists in all of the rows above it for that column.
Why is that occurring and how to correct it?
Please see attached image for example.