... to open a raw yield file in Excel?    And if you are talking about the ascii export from the AFS software, then you would have already been through their reading process.   The Excel file would only contain the site that are displayed within the AFS map.

You could try to read the raw yield files into a different software package and see if it handles the data differently.