Dear Amacintyre,
This might happen because of the Primavera P6 version and/or project name and user preferences. I believe you managed to pass this issue for future similar issues it is better to export spread sheet from P6 and edit the information inside rather than using an excel sheet for import from another PC/user.