N/APosted on - 05/29/2015
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?
Microsoft Excel freezes for every safe operation
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.