While working in Excel, have you ever encountered #N/A or #REF! or #VALUE! or any other error starting with # ?
Here's a good article that provide details on why such errors appear in Excel.
PS:
You must remove all such errors from your Excel data before trying to import data into Tally.