Limit to amount of records copied to clipboard when selecting all records in a pivot table


So I have a pivot table with a total of 1086 records.

After selecting all data, I copy and paste into one of my tables, but it seems to be only able to commit up to 1000 records to the clipboard.

I have not reached the record limit for our plan, and to confirm this I pasted the data onto Excel, which still shows only 1000 rows pasted.

Can somebody shed light onto this please, as I need to be able to copy all data from our pivot blocks onto the tables.