Journal in a Spreadsheet Error

Summary

Receiving "The combination is not valid" error when combination is valid

Content

We have users copying and pasting values from other workbooks to a journal spreadsheet. On a percentage of the lines the spreadsheet is throwing "The combination is not valid" error even though the combination is valid. When we double-click the combination and the window pops up the values that are in the spreadsheet are not populating into the combination window. After we update the combinations manually in that window the journal accepts the combination. This is happening on like 10-25% of the rows. Once I fix one row with a combination, suddenly all the rows with that combination work.