Home

Excel stutters and freezes

%3CLINGO-SUB%20id%3D%22lingo-sub-295247%22%20slang%3D%22en-US%22%3EExcel%20stutters%20and%20freezes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295247%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20running%20Excel%20(out%20of%20Office%20365%20Business)%20on%20an%20Intel%20Core%20i7%20920%20CPU%20(2.67%20GHz)%20with%2012%20GB%20RAM.%3C%2FP%3E%3CP%3EFor%20a%20client%2C%20I%20am%20analysing%20data%20that%20doesn't%20have%20that%20many%20columns%2C%20but%20all%20sources%20combined%20has%20almost%20600%2C000%20rows.%20Now%20whenever%20I%20as%20much%20as%20try%20to%20do%20something%20(such%20as%20opening%20a%20filter%20button%20to%20change%20the%20filter)%2C%20Excel%20starts%20stuttering%20and%20freezing%20and%20the%20CPU%20load%20goes%20through%20the%20roof%20(~20%25).%20At%20the%20same%20time%2C%20the%20task%20manager%20still%20shows%20free%20memory%2C%20and%20freeing%20more%20memory%20by%20closing%20the%20web%20browser%20didn't%20help%20at%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20nothing%20in%20terms%20of%20formulas%20in%20there%2C%20yet%2C%20just%20an%20ID%20and%20measurement%20results%20for%20several%20parameters%20for%20each%20ID.%20The%20file%20is%2035MB%20large.%26nbsp%3BMy%20PC%20has%20handled%20files%20of%20that%20size%20and%20even%20much%20larger%20reasonably%20well%20in%20the%20past%2C%20so%20possibly%2C%20the%20problems%20came%20with%20an%20update%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20even%20tried%20repairing%2C%20then%20reinstalling%20Office%2C%20to%20no%20avail%2C%20and%20by%20now%20am%20at%20a%20loss%20and%20my%20client%20is%20getting%20a%20bit%20impatient%20as%20to%20when%20I'm%20done%20analyzing%20the%20data.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-295247%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-295478%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stutters%20and%20freezes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295478%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%2C%20that%20didn't%20really%20help.%20Half%20an%20hour%20or%20so%20after%20clicking%20the%20button%2C%20the%20filter%20choice%20panel%20will%20pop%20up%20over%20whichever%20window%20I%20am%20in%20at%20that%20time%2C%20but%20will%20disappear%20before%20I%20can%20make%20any%20choice.%20Then%2C%20Excel%20will%20be%20running%20normally%20until%20such%20point%20I%20tell%20it%20to%20actually%20do%20something%20-%20the%20slightest%20action%2C%20even%20if%20just%20entering%20letters%20into%20a%20cell%2C%20will%20make%20it%20freeze%20within%20seconds%20again%2C%20giving%20me%20the%20hourglass%20and%20making%20the%20program%20unresponsive%20for%20yet%20another%20eternity...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-295249%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20stutters%20and%20freezes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-295249%22%20slang%3D%22en-US%22%3E%3CP%3ESave%20as%20file%20with%20F12%20in%20Binary%20format%2C%20it%20will%20reduce%20file%20size%20almost%201%2F5th%20of%20what%20it%20is%20and%20try%20out%20again%20to%20work%20in%20your%20file...may%20be%20it%20will%20help%20you...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Hydroxide
New Contributor

I'm running Excel (out of Office 365 Business) on an Intel Core i7 920 CPU (2.67 GHz) with 12 GB RAM.

For a client, I am analysing data that doesn't have that many columns, but all sources combined has almost 600,000 rows. Now whenever I as much as try to do something (such as opening a filter button to change the filter), Excel starts stuttering and freezing and the CPU load goes through the roof (~20%). At the same time, the task manager still shows free memory, and freeing more memory by closing the web browser didn't help at all.

 

There's nothing in terms of formulas in there, yet, just an ID and measurement results for several parameters for each ID. The file is 35MB large. My PC has handled files of that size and even much larger reasonably well in the past, so possibly, the problems came with an update?

 

I even tried repairing, then reinstalling Office, to no avail, and by now am at a loss and my client is getting a bit impatient as to when I'm done analyzing the data. 

2 Replies

Save as file with F12 in Binary format, it will reduce file size almost 1/5th of what it is and try out again to work in your file...may be it will help you...

Highlighted

Unfortunately, that didn't really help. Half an hour or so after clicking the button, the filter choice panel will pop up over whichever window I am in at that time, but will disappear before I can make any choice. Then, Excel will be running normally until such point I tell it to actually do something - the slightest action, even if just entering letters into a cell, will make it freeze within seconds again, giving me the hourglass and making the program unresponsive for yet another eternity...

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies