Cannot get column to automtically match on Import from Clipboard

Typically, when you copy and paste from an excel sheet and perform an import, as long as your column heading matches exactly, QuickBase can guess correctly and match which field to import to.

This has worked flawlessly for me, until now. I have one column, that no matter what will not match itself up (not an impossible situation, I simply select the correct column when importing, but sometimes if I am going to fast I miss it, and it would be nice to not worry about it).

The Column name in excel (and indeed the field name in QB) is 'Project ID and MonthYear'. I know the names match because I copy/pasted my field name to my excel sheet header.

However, when I import it always auto selects a field named 'Summary Key Month Manual'. Even if I change the name of this field to 'testing new name', it will always select this particular field in its attempt to match.

One other note: 'Project ID and MonthYear' is a text field and also the key field and merge field in this particular table. Not sure if that has anything to do with it?

Thoughts of what it could be, or how to troubleshoot? Why does it auto select this field to match?

------------------------------
Mike Tamoush
------------------------------