Microsoft Excel freezes for every safe operation

Asked By 0 points N/A Posted on -
qa-featured

I have a datasets in csv format which I always load onto excel. I do some manipulations of the data and filter out a few rows based on the results I obtain. Then I will plot the data and save it with the file name same as dataset name for further reference . This is common in my job and was able to do it easily. But recently after a windows updates, I don’t know whether it is related or not but still, whenever I click on the save button, it simply blurs itself for few seconds and saves. Sometimes this will take so long that I am forced to use task manager to kill that Excel and of course all my work.why is this happening? Is it related to any updates? Can I uninstall a few updates and try again?

SHARE
Answered By 0 points N/A #194121

Microsoft Excel freezes for every safe operation

qa-featured

You can follow the below solutions to resolve the freezing issue of Microsoft Excel:

Solution 1: Install the latest updates.

Set windows update automatically and install the recommended updates.

Start -> Control panel -> system and security -> Windows update -> change settings -> select option ‘install updates automatically’ from ‘Important update options. Enable the recommended update option also.

Solution 2: Clear the files from Excel startup folders from the locations mentioned below and check the result:

1. C:Program FilesMicrosoft OfficeOffice14XLStart

2. C:UsersUser NameAppDataRoamingMicrosoftExcelXLSTART Note: Take a backup of files before deleting the files.

Solution 3: Check for ads in issues

1. Start -> type ‘Excel /safe’ in the search bar -> click on excel /safe -> click OK.

Note: There is a space in between excel and /.

2. If the issue is resolved, open the file menu -> click Options then Add-ins -> select COM Add-ins and click Go.

3. Clear all the check boxes (Disable the Add-ins.) in the list and click OK.

4. Close and restart Excel.

Note: If the issue does not occur, start enabling the add-ins one at a time until the issues occurs. This will allow you to figure out which add-in is causing the problem. Be sure and restart Excel each time you enable an add-in. If disabling add-ins did not resolve your issue, continue on to the next item on the list.

Solution 4: Repair Microsoft Office programs.

Solution 5: Check and keep the anti-virus up-to-date.

Login/Register to Answer

Related Questions