Excel causes CPU usage to go up to 100%

Danny1

New member
Local time
12:16 PM
Messages
19
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".
 

My Computer My Computer

At a glance

Microsoft Windows 7 Home Premium 64-bit 7601 ...AMD Athlon(tm) II P340 Dual-Core Processor4.00 GBATI Mobility Radeon HD 4200 Series
Computer type
PC/Desktop
OS
Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
CPU
AMD Athlon(tm) II P340 Dual-Core Processor
Motherboard
TOSHIBA Portable PC
Memory
4.00 GB
Graphics Card(s)
ATI Mobility Radeon HD 4200 Series
Sound Card
Conexant CX20671 SmartAudio HD
Screen Resolution
1366 x 768 x 32 bits (4294967296 colors) @ 59 Hz
Hard Drives
ST9250315AS ATA Device
Your system specs look fine, you should be good on resources...

That is quite a large excel file. What version of office are you using? Have you tried a detect and repair on the excel file? You can do this by opening excel, and choose file open. Then click the file once to select it. Click the drop down arrow next to open and choose detect and repair. This will typically fix most issues with a a file made in office without losing your data. How long have you had this issue? When did it start?
 

My Computer My Computer

At a glance

Windows 10 ProAMD Ryzen 5 2400G Processor with Radeon RX Ve...G.SKILL Ripjaws V Series 16GB (2 x 8GB) 288-P...2047MB NVIDIA GeForce GTX 1060 6GB (EVGA)
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Custom Built
OS
Windows 10 Pro
CPU
AMD Ryzen 5 2400G Processor with Radeon RX Vega 11 Graphics
Motherboard
ASRock X470 Master SLI/AC AM4 AMD Promontory X470 SATA 6Gb/s
Memory
G.SKILL Ripjaws V Series 16GB (2 x 8GB) 288-Pin DDR4 SDRAM D
Graphics Card(s)
2047MB NVIDIA GeForce GTX 1060 6GB (EVGA)
Sound Card
Motherboard Built in
Monitor(s) Displays
Acer R240HY bidx 23.8-Inch IPS HDMI DVI VGA (1920 x 1080) Wi
Screen Resolution
1920 x 1080
Hard Drives
1TB Sandisk SSD PLUS (Main drive)
500 GB Seagate 7200 RPM (Games)
500 GB Western Digital 7200 RPM (Virtual Machines)
PSU
CORSAIR TX Series TX650M 650W 80+ Gold Modular Power Supply
Case
CORSAIR CARBIDE SPEC-02 Mid-Tower Gaming Case, Red LED Fan
Cooling
220mm, two 120mm, and four 60mm fans
Keyboard
Wired Dell keyboard
Mouse
Wireless Logitech mouse
Internet Speed
250mb down, 30mb up
Antivirus
Panda Cloud Antivirus
Browser
Chrome-ish x64
Other Info
Your awesome for reading this.
Back
Top