Copy-pasting unsorted filtered data causes Excel to freeze for 2 minutes
Copy-pasting the visible cells on a filtered selection of unsorted data causes Excel to freeze for 2 minutes before the data is pasted in a new sheet.
However, when performing a sort first before applying the filter, the data is pasted instantaneously.
We are running Microsoft Excel for Office 365 MSO (16.0.11328.20362) 32-bit / Click-to-run / semi-annual channel / Version 1902
Steps to simulate the issue can be found in the attached PDF document.
Premier support request 119073025000295 created regarding this issue