Is Microsoft Excel freezing when copying and pasting data on cells?
Microsoft Excel is one of the best spreadsheet tools for PC. Depending on the file you are accessing, Excel can take up a lot of your system resources, especially when processing hundreds or thousands of cells.
Due to this, many users encounter performance issues with Microsoft Excel when accessing their files on an entry-level system.
Recently, there have been complaints from several users who encounter freezing problems when copying and pasting data on cells. Most of the time, this issue is caused by a hardware bottleneck.
When processing thousands of data, Microsoft Excel will require more computing power from your CPU. If your system can’t deliver the power, you’ll start to encounter lags and other issues on Excel.
On the other hand, this problem could also be due to third-party applications, improper configurations, or corrupted data.
Today, we will show you what to do if Microsoft Excel is freezing when copying and pasting data.
Let’s get started!
1. Restart Your Computer.
Performance issues on your computer are often caused by temporary bugs and glitches in your system. To fix this, you can try restarting your computer to flush out temporary data and caches and eliminate errors in the process.
Here’s how you can restart your computer:
- First, save your progress and ensure that Microsoft Excel is closed.
- After that, access the Start Menu and click on the Power Options tab.
- Lastly, choose Restart and wait for your computer to reboot.
Once done, go back to Microsoft Excel and see if its performance improved.
2. Close Unused Applications.
Third-party applications could also be the reason you encounter freezing issues on Microsoft Excel. Your system could be running out of resources, which affects Excel’s performance. To ensure your computer has enough CPU cores and RAM, try turning off unused applications in the background.
- First, launch the Task Manager by pressing CTRL + SHIFT + ESC on your keyboard.
- After that, go to the Processes tab and click on CPU or RAM to sort your apps based on their usage.
- Lastly, identify the applications you are not using and close them.
Go back to Microsoft Excel and check if the problem is solved.
3. Remove Conditional Formatting.
Conditional formatting on Microsoft Excel can put a lot of load on your system when copying them from one cell to another. Due to this, we recommend disabling conditional formatting on your data before pasting them on other cells.
Here’s what you need to do:
- On Microsoft Excel, go to the Home tab.
- Next, click on Conditional Formatting under the Styles tab.
- After that, hover your cursor over the Clear Rules option.
- Finally, select the option you need to clear.
Once done, go back to your spreadsheet and see if the problem is solved.
4. Remove Issues on Your Document.
Excel has a built-in tool that lets you scan your document for hidden properties or personal information that has issues.
Check out the steps below to access it:
- First, click on the File tab and choose Info.
- After that, select the Check for Issues option and click on Inspect Document.
- On the next window, click on Inspect and wait for the scan to complete.
- Lastly, click on Remove All if the tool detected issues.
Restart Microsoft Excel afterward and check if the problem is solved.
5. Update Microsoft Excel.
Some of Microsoft Excel’s resources may have gotten corrupted during use, which causes performance issues on the app. You might also be using a build that has existing issues, which explains the problem.
To fix this, see the steps below to update Microsoft Excel:
- First, open Microsoft Excel and access the File tab.
- Now, go to Accounts.
- Lastly, click on Update Options and choose Update Now or Enable Updates.
Relaunch Microsoft Excel and see if you’ll still encounter performance issues.
6. Remove Excel Cache Files.
Clearing your cached files could also help address performance issues in Microsoft Excel. This should free up space in your storage and eliminate corrupted data from your system.
Check out the steps below to clear Excel’s cache files:
- On your keyboard, press the Windows + R keys to open Run.
- Next, type ‘%LOCALAPPDATA%\Microsoft\Office\16.0\Wef\’ and click OK.
- Finally, delete all the contents of the folder.
Once done, restart your computer and check if the problem is solved.
7. Reinstall Microsoft Excel.
If none of the solutions above worked for you, the last thing you can do is reinstall Microsoft Excel. This should ensure that you have the latest working copy of the app and there are no missing files on your system.
Follow the guide below to uninstall Microsoft Excel:
- On your computer, go to the Control Panel and click on Uninstall a Program.
- Look for Microsoft Excel afterward and right-click on it.
- Finally, choose Uninstall and follow the prompts.
Reinstall Microsoft Excel afterward and see if the problem is solved.
That sums up our guide for fixing Microsoft Excel if it’s freezing when copying and pasting data. If you have other concerns, please voice them out in the comment section, and we’ll do our best to help.
If this guide helped you, please share it. 🙂