Microsoft Excel has now become an integral part of our lives. While working with Excel sheets, sometimes we come across certain errors such as Excel not responding. This kind of error can occur when doing simple tasks such as switching between the worksheets or when copying and pasting data within the sheet.
How to fix Excel not responding without losing data?
If Excel stops responding when switching between worksheets, you can follow the suggestions in this post to resolve the problem without losing data.
- Remove the filter from the affected worksheet.
- Set a registry key
Let us look at these solutions in more detail.
1] Remove the filter from the affected worksheet
To do so, follow the next steps:
- Open the File.
- Now go to Home
- Go to Sort & Filter Click on the drop-down arrow and click on Clear.
See if this solution helps you in resolving the issue.
Read: Excel freezes when copying and pasting
2] Set a registry key
Make sure to back up the registry before you modify it. After that, follow the next steps for setting a registry key.
- Open Registry Editor by pressing the Windows key + R. This opens the Run window.
- Now types regedit and press Enter. This opens the Registry Editor.
- Now navigate to the following registry key:
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Excel\Options
- In the right pane, locate the registry value, DisableTouchUIA, with the type REG_DWORD.
- If the value does not exist, you can create it by selecting Edit > New > DWORD (32-bit) Value
- Then type DisableTouchUIA to set the name of the new registry value.
- Now, select DisableTouchUIA and then select Modify
- Set the Value Data to 1.
- Now click OK.
Try these resolutions and see if the issue with Excel not responding is resolved.
Why is my Excel not copying and pasting?
This could be because the copied area and the Paste area are not the same size and shape. In such a case, select the upper-left cell instead of the whole range before you paste. Click the cell where you want the upper-left cell of the copied data to appear. On the Home tab, click Paste.
Why is my Excel file freezing?
Most of the time, the Excel file is not the problem but the add-ins are. Sometimes, macros or software installed cause the Excel file to freeze. Some Excel file users have also reported that Windows updates and Virus scanners are the sources of error. To know more about the causes and their resolutions, read the article.
I could not save the Excel sheet and now it is not responding. What should I do?
This issue needs to be addressed a bit differently.
In case you have saved the Excel worksheet previously, but you were not able to save your last changes, because the Excel sheet is not responding, you can try to recover the worksheet with the Document Recovery feature.
Close the worksheet. Now open it again. Most of the time, when you open the sheet again, Microsoft shows an option with the name Recovered on the left side of the Start page. Now click on Show Recovered Files.
When you see the Document Recovery option on the left side pane, you can also try to find the workbook displaying under Available Files.
