CPU usage at 100% while running Excel

Danny1

Well-Known Member
#1
I have a rather large Excel file (around 100 MB) and it is very slow when I make changes to it or save it. The task manager shows that my CPU usage is upwards toward 100%. It says that "Excel cannot complete this task with available resources".
 


#2
What kind of computer are you using...desktop/laptop? What other programs are you running, while running Execl?
 


patcooke

Microsoft MVP
Staff member
Premium Supporter
Microsoft MVP
#3
The resources problems in Excel are well known and documented. The cause unfortunately is not so easy to pinpoint depending on the various combinations of features which are being used. One simple thing worth trying is to set the formula recalculations to manual to avoid the possibility of entering into a very long chain of events each time a change is made.
 


Josephur

Windows Forum Admin
Staff member
Premium Supporter
#4
You can also try disabling 3rd party add-ons from loading with Excel, before you try that I would try Excel Safe Mode first (hold down CTRL key while launching Excel).
 


Pauli

Extraordinary Member
Premium Supporter
#5
The worst scenario is the CPU100 phenomenon, meaning you have a virus running. It should "work" with other programs too, not only Excel.
 


#6
100% usage? Your Excel file maybe has the Macro virus, use the AVG or Advanced SystemCare ultimate to check it.
 


Pauli

Extraordinary Member
Premium Supporter
#7
If it is Macro Virus, it's probably installed, and has to be uninstalled, http://www.emsisoft.com/en/malware/Adware.Win32.MacroVirus-remove.aspx

Not sure, but check your installed programs.

==========================================================================

Has anyone else noticed, that we seem to get more and more of installed harmful programs? It's not some cookies, it's stuff that gets installed? And they don't necessarily show in Control Panel, or Revo - they only have their own uninstall... comes the day when they don't even have that? Don't get any less gray hair... blaah.
 


This website is not affiliated, owned, or endorsed by Microsoft Corporation. It is a member of the Microsoft Partner Program.