Have you ever encountered the Excel freezes when copying and pasting issue?

When you face this problem, you cannot copy and paste in Excel.

Excel is a powerful spreadsheet program from Microsoft that is always used to organize data and perform financial analysis.

Best Fixes to We’re Sorry but Excel Has Run Into an Error

Today we are going to show you what to do when Excel freezes when copying and pasting.

Received the error alert Were sorry but Excel has run into an error while opening Excel?

Now get rid of it by reading this article.

clear rules

Fix 2.

Therefore, you’re free to follow the steps below to clear all conditional formatting.

Step 1. bring up the Excel file.

disable live preview

ClickHome>Conditional Formatting>Clear Rules.

Step 3. choose the appropriate option from the rules list.

After that, restart Excel and check whether the issue has been resolved.

Three Ways on How to Reset Excel to Default Settings

According to the Internet, enabled live preview can be responsible for the Excel frozen issue.

Here you could disable it when Excel crashes when copying a sheet.

In Excel, clickFile>Options.

clear add-ins cache

In theGeneralsection, uncheck the checkbox ofEnable Live PreviewunderUser Interface options.

ClickOKto back up your changes and restart Excel.

Then check whether it’s possible for you to copy and paste normally in Excel.

Disk Cleanup Not Deleting Files | Best Practice Solutions

Fix 4.

So, you better delete these cache files.

PressWindows + Rkey combinations toopen Run.

go to COM Add-ins

In the pop-up window, throw in%LOCALAPPDATA%\Microsoft\Office\16.0\Wef\and pressEnter.

Step 3. pick the cache files and right-click them to chooseDelete.

Open an Excel spreadsheet.

scan the desktop individually

ClickFile>Options>Trust Center>Trust Center tweaks.

ClickOKto stash your changes.

Step 4. cycle your Excel.

Disk Cleanup not deleting files Windows 10/11?

Here this article offers you several methods to address the Disk Cleanup not working issue.

Fix 5.

Disable All Add-Ins

Add-insadd new features to Microsoft Excel, making it easier to manage your sheets.

However, sometimes some Excel add-ins may conflict with Excel causing Excel freezes when copying and pasting.

PressWindows + Rkeyboard shortcuts and typeexcel /safein the input box.

ClickFile>Options>Add-ins.

In the bottom area, selectCOM Add-insand clickGo.

Fix 6.

Repair Microsoft Office

Repairing Office is also a good solution to the Excel frozen issue.

ManyMicrosoft Office repair toolscan help you accomplish the repair task.

The free edition of MiniTool Power Data Recovery allows you to recover 1 GB of files for free.

Doing this can improve data recovery efficiency and save you much time.

Just try the methods mentioned above.