I have a name conflict message which I cannot get rid off

Go to Formulas -> Name Manager, select the whole list in the pop up box and press Delete

Refer this ...
https://superuser.com/questions/377664/stop-excel-formula-or-sheet-contains-the-name-dialog