Pasting large amounts of data from desktop defaults to text only in Excel Online

Hi all,

I've recently had this issue where the data that I copy from the desktop version of Excel automatically defaults to text only values when I paste it in the web version of Excel. It seems to work fine when I paste small amounts of data but not large.

Does anyone know how I can stop this from happening?

Thanks in advance.