Dia duit,
To better assist you, I have two questions:
1. On the third spreadsheet, is the default Excel dropdown list updating properly?
2. If the default dropdown list is updating correctly on the third spreadsheet, please take a screenshot of the data validation settings of the dropdown list and share it with us.
By confirming these details, we can pinpoint the issue more accurately and provide you with the appropriate solution.
Go raibh maith agat as do chomhoibriú agus do thuiscint.
Amanda