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, an...

I want to know if there is a way we can treat a pivot block as a table, so that I can link Table A to this pivot block. Then in Table A, I would like to have a lookup column where it can pull in data from fields within the pivot block. Any advise wou...