Update drop down menu data when source is updated

[hostman]

Hi,

Hopefully someone can give me some guidance on this rather annoying problem.

I've created a relatively simple Excel workbook, it is for scoring CVs based on applicants meeting various criteria.

There are 13 criteria in total, each has a score. The score could vary for each criteria, it could 0, 5, 10, 15 or -15.

I've created drop down menus for each criteria, allowing a member of staff to read a CV and give the appropiate score if the criteria is matched. Then there is a very simple autosum at the end to add up the total for each applicant.

This part works as expected.

However, there may be a requirement to update the scores. For example we've got 100 CVs to go through, the scores we've assigned to various criteria might return unexpected results once we've processed each one.

At the moment, if I update the score data, any drop downs which are pre-selected with the previous score do not update. You can only see the new number if you reselect the score.

I want this part to be automatic and I am surprised it is not anyway. I'm either approaching this the wrong way, or there is a quirk to get this method working as expected.

Attached is the workbook.