Windows 7 CPU usage at 100% while running Excel

Danny1

Well-Known Member
Joined
Oct 20, 2012
Messages
60
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".
 


Solution
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.
What kind of computer are you using...desktop/laptop? What other programs are you running, while running Execl?
 


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.
 


Solution
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).
 


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


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


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.
 


Back
Top