Not a proper answer but i got round the issue by importing the data into another part of the spreadsheet and then using a secondary macro to copy that data and paste it into the table and then delete the original import.