I think this case you need to contact to Tableau Technical Support.
No exactly same issue, but I encountered the problem that
I could not copy paste the value from excel to tableau which had some complicated formula.
(a that time randbetween with version 9.2)
If you don't mind, could you try copy paste with only value(eliminating formula and only value in another sheet)
and connect to that sheet?
I think that helps Tableau technical team investigating the issue.