You might see on your unlinked report that your ID number looks a bit funky:
This is just Excel's way of displaying it; it's a different format.
To resolve it, you can select your ID number column, click on the format dropdown on your Home ribbon, and select number.
Your ID numbers should reflect correctly now:
