Limit to amount of records copied to clipboard when selecting all records in a pivot table
Topic Labels:
Extensions
0
1544
0
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.
Thanks.
