Microsoft Excel has now grow to be an integral a part of our lives. Whereas working with Excel sheets, typically we come throughout sure errors equivalent to Excel not responding. This type of error can happen when doing easy duties equivalent to switching between the worksheets or when copying and pasting knowledge inside the sheet.
How to fix Excel not responding without losing knowledge?
If Excel stops responding when switching between worksheets, you may observe the ideas on this publish to resolve the issue without losing knowledge.
- Take away the filter from the affected worksheet.
- Set a registry key
Allow us to have a look at these options in additional element.
1] Take away the filter from the affected worksheet
To take action, observe the subsequent steps:
- Open the File.
- Now go to Dwelling
- Go to Kind & Filter Click on on the drop-down arrow and click on on Clear.
See if this resolution helps you in resolving the difficulty.
Learn: Excel freezes when copying and pasting
2] Set a registry key
Be certain to again up the registry earlier than you modify it. After that, observe the subsequent steps for setting a registry key.
- Open Registry Editor by urgent the Home windows key + R. This opens the Run window.
- Now varieties regedit and press Enter. This opens the Registry Editor.
- Now navigate to the next registry key:
HKEY_CURRENT_USERSOFTWAREMicrosoftOffice16.0ExcelOptions
- In the fitting pane, find the registry worth, DisableTouchUIA, with the sort REG_DWORD.
- If the worth does not exist, you may create it by deciding on Edit > New > DWORD (32-bit) Worth
- Then kind DisableTouchUIA to set the title of the brand new registry worth.
- Now, choose DisableTouchUIA after which choose Modify
- Set the Worth Knowledge to 1.
- Now click on OK.
Attempt these resolutions and see if the difficulty with Excel not responding is resolved.
Why is my Excel not copying and pasting?
This might be as a result of the copied space and the Paste space are not the identical measurement and form. In such a case, choose the upper-left cell as an alternative of the entire vary earlier than you paste. Click on the cell the place you need the upper-left cell of the copied knowledge to seem. On the Dwelling tab, click on Paste.
Why is my Excel file freezing?
More often than not, the Excel file is not the issue however the add-ins are. Typically, macros or software program put in trigger the Excel file to freeze. Some Excel file customers have additionally reported that Home windows updates and Virus scanners are the sources of error. To know extra in regards to the causes and their resolutions, learn the article.
I may not save the Excel sheet and now it’s not responding. What ought to I do?
This concern wants to be addressed a bit otherwise.
In case you have got saved the Excel worksheet beforehand, however you had been not in a position to save your final adjustments, as a result of the Excel sheet is not responding, you may attempt to get better the worksheet with the Doc Restoration function.
Shut the worksheet. Now open it once more. More often than not, while you open the sheet once more, Microsoft reveals an choice with the title Recovered on the left aspect of the Begin web page. Now click on on Present Recovered Recordsdata.
Whenever you see the Doc Restoration choice on the left aspect pane, you may as well attempt to discover the workbook displaying below Accessible Recordsdata.
Learn: Excel is gradual to reply or stops working.
