Trying to clear the cache files will lose the burden on Excel and it won’t freeze. Method 2: Delete Cache FilesĮxcel starts getting freeze whenever the cache gets overloaded. If you did not experience any Excel not responding when pasting then narrow down the section that is causing the problem and apply the conditional formatting again. Below are the steps that are given to perform conditional formatting:
So, to speed up the work in Excel and stops it from freezing again you can try clearing the conditional formatting. Many a time it happens that Excel file slows down or freezes while working. Try the following steps one by one to resolve Excel not responding when copying and pasting the data. There are many solutions that will help you to make Excel work without freezing.
How To Resolve Excel 2016 Keep Freezing When Copying Pasting?