I am trying to map territories by postcode district in MP. I am using a link to an Excel workbook so that i can manipulate the areas and update the map ongoing.

Problem is that whilst MP creates the initial territory map, it wont update when i adjust the Excel sheet. I have tried taking this down to postcode area instead and it works fine.

When i first link the Excel sheet, there are quite a few districts that dont match (122 in total) - i thought this may have something to do with it, but after manually changing all of these 122 codes to a recognised format, it still doesnt update

Any ideas?