Excel operates very slowly and stops responding constantly, how to fix?

%3CLINGO-SUB%20id%3D%22lingo-sub-1294170%22%20slang%3D%22en-US%22%3EExcel%20operates%20very%20slowly%20and%20stops%20responding%20constantly%2C%20how%20to%20fix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294170%22%20slang%3D%22en-US%22%3E%3CP%3EI%20downloaded%20Microsoft%20office%20365%20today%2C%20alongside%20all%20of%20its%20applications%2C%20and%20I%20am%20having%20trouble%20opening%20and%20using%20Excel.%20I%20tried%20opening%20all%20other%20Microsoft%20Office%20softwares%2C%20such%20as%20Word%20and%20PowerPoint%2C%20and%20they%20all%20work%20flawlessly.%20However%2C%20Excel%20takes%20much%20longer%20to%20open%20up%20than%20the%20other%20softwares%2C%20and%20even%20when%20it%20does%20open%20up%20it%20stops%20responding%20after%20every%20button%20I%20click.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20tried%20following%20the%20Microsoft%20excel%20not%20responding%20guide%2C%20but%20it%20has%20not%20fixed%20my%20issue.%20Is%20there%20anybody%20who%20might%20have%20an%20idea%20on%20how%20to%20fix%20this%20issue.%3CBR%20%2F%3E%3CBR%20%2F%3EI'll%20list%20what%20I%20have%20tried%20doing%20to%20fix%20Excel%3A%3CBR%20%2F%3E-%20Uninstalling%2C%20and%20reinstalling%20Office%20365%3CBR%20%2F%3E-%20Used%20Apps%20and%20Features%20to%20try%20and%20repair%20Office%20365%20(Both%20Quick%20and%20Online%20Repair)%3CBR%20%2F%3E-%20Tried%20running%20Excel%20in%20Safe%20mode%20to%20see%20if%20it%20were%20to%20run%20properly%2C%20it%20does%20not%3CBR%20%2F%3E-%20Tried%20deleting%20XLSTART%20found%20at%20C%3A%5CUsers%5CUser_Name%5CAppData%5CRoaming%5CMicrosoft%5CExcel%20(I%20kept%20a%20back%20up%20the%20file%20somewhere%20else)%3CBR%20%2F%3E-%20Disabling%20Hardware%20Graphic%20Acceleration%20in%20the%20options%3CBR%20%2F%3E-%20Checking%20for%20Windows%20update%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20anybody%20has%20any%20suggestions%20on%20how%20to%20fix%20this%20issue%2C%20I%20would%20greatly%20appreciate%20it.%3CBR%20%2F%3EP.S.%20I%20am%20running%20Windows%2010%2C%20and%20I%20am%20using%20the%20latest%20version%20of%20Excel%3CBR%20%2F%3E%3CBR%20%2F%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1294170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Adoption%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1294315%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20operates%20very%20slowly%20and%20stops%20responding%20constantly%2C%20how%20to%20fix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294315%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F615019%22%20target%3D%22_blank%22%3E%40Justin_R%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20had%20an%20experience.%20If%20the%20excel%20file%20is%20located%20in%20Google%20Drive%20File%20Stream%2C%20the%20performance%20will%20be%20down-graded.%20As%20the%20file%20I%20am%20using%20contains%20a%20lot%20of%20macros%2C%20sometimes%20it%20will%20prompt%20a%20dialog%20box%20saying%20that%20%22Excel%20is%20waiting%20for%20OLE%20connection%22%20(something%20like%20that%2C%20I%20forgot%20the%20exact%20wording).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20suggestion%20is%20the%20calculation.%20In%20case%20the%20file%20contains%20a%20lot%20of%20formulas%20(OFFSET%2FCOUNTIF)%20and%20the%20calculation%20mode%20is%20automatic%2C%20it%20will%20also%20slow%20down%20the%20operation.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1294413%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20operates%20very%20slowly%20and%20stops%20responding%20constantly%2C%20how%20to%20fix%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294413%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F53148%22%20target%3D%22_blank%22%3E%40Man%20Fai%20Chan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20information.%20Unfortunately%20however%2C%20my%20problem%20is%20not%20solely%20related%20to%20a%20single%20excel%20file%2C%20but%20the%20entire%20program%20itself.%20The%20problem%20begins%20before%20the%20loading%20of%20any%20file%20and%20persists%20to%20happen%20after%20any%20file%20is%20loaded.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20do%20not%20find%20a%20better%20solution%2C%20I%20think%20the%20only%20solution%20I%20have%20left%20is%20to%20recover%20my%20storage%20drives%20to%20before%20the%20installation%20of%20all%20my%20softwares%20and%20reinstall%20everything.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I downloaded Microsoft office 365 today, alongside all of its applications, and I am having trouble opening and using Excel. I tried opening all other Microsoft Office softwares, such as Word and PowerPoint, and they all work flawlessly. However, Excel takes much longer to open up than the other softwares, and even when it does open up it stops responding after every button I click.

I have tried following the Microsoft excel not responding guide, but it has not fixed my issue. Is there anybody who might have an idea on how to fix this issue.

I'll list what I have tried doing to fix Excel:
- Uninstalling, and reinstalling Office 365
- Used Apps and Features to try and repair Office 365 (Both Quick and Online Repair)
- Tried running Excel in Safe mode to see if it were to run properly, it does not
- Tried deleting XLSTART found at C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (I kept a back up the file somewhere else)
- Disabling Hardware Graphic Acceleration in the options
- Checking for Windows update

If anybody has any suggestions on how to fix this issue, I would greatly appreciate it.
P.S. I am running Windows 10, and I am using the latest version of Excel

Thanks.

2 Replies
Highlighted

@Justin_R 

 

I had an experience. If the excel file is located in Google Drive File Stream, the performance will be down-graded. As the file I am using contains a lot of macros, sometimes it will prompt a dialog box saying that "Excel is waiting for OLE connection" (something like that, I forgot the exact wording). 

 

Another suggestion is the calculation. In case the file contains a lot of formulas (OFFSET/COUNTIF) and the calculation mode is automatic, it will also slow down the operation. 

Highlighted

@Man Fai Chan 

 

Thank you for the information. Unfortunately however, my problem is not solely related to a single excel file, but the entire program itself. The problem begins before the loading of any file and persists to happen after any file is loaded.

 

If I do not find a better solution, I think the only solution I have left is to recover my storage drives to before the installation of all my softwares and reinstall everything.