Just to finalise this thread, it was something silly within my workbook - never found out what.
Just had to delete each named range one by one using vba.