Jump to content

CPU Maxing Out

I have a fairly new HP PC with an m.2 drive and 16gb RAM with an i7-8300 cpu. For some reason, when working in excel, the cpu usage shoots up to 100% and the pc literally comes to a standstill. This particular spreadsheet is 28mb in size and there is nothing else open on the PC. When I look at task manager, it is literally just Excel eating up 98-99% cpu, nothing else.

 

To put this in perspective, we have a much much older Lenovo laptop whos specs are far far worse, and it runs this spreadsheet, and others that are even bigger, with no issues at all. Does any one know what could be causing this please? Thank you!

CPU: i5-4690K @ 3.5GHz || MoBo: Asus H81M-C || RAM: 16gb Kingston HyperX Blue || Cooler: Stock intel cooler || GPU: Palit GTX 1050 || PSU: Can't remember exactly but know it meets the needs of my components || Case: White Falcon Case || SSD: Kingston 120GB || Storage: WD Blue 1TB

Link to comment
Share on other sites

Link to post
Share on other sites

What version of excel are you running and what OS?

Internet Connection

My Rig: AMD Ryzen 9 3900X @ 4.3Ghz | Asus Prime X470-Pro | Corsair Vengeance RGB Pro 32 GB (4 x 8GB) DDR-4 3000Mhz OC'd @ 3400Mhz 16-20-20-38 |

EVGA RTX 2070 8GB XC Gaming OC @ 2145Mhz Boosted/ 1925Mhz Memory | WD SN750 500GB M.2 NVME | Gigabye 240GB SSD | 
XSPC EX 360mm | Corsair XC7 RGB CPU WB | EK-Vector RTX 2080 | Alphacool Eisbecher D5 150mm Plexi | XSPC Fittings | XSPC FLX Clear 7/16" ID, 5/8" OD |
Corsair LL120 x6 | Corsair RM750x White 2018 | Corsair Commander Pro | Corsair Obsidian 500D RGB SE | Corsair RGB LED Lighting PRO Expansion |
Corsair Strafe RGB MK.2 | Corsair Ironclaw RGB Wireless 18,000DPI | Acer 32" 4K 60Hz HDR600 Cert. ET322QK CBMIIPZX |

Passmark Score

3dmark Score

PC Parts Picker Link to Build

Network

Netgear LBR20 LTE Router | Verizon Unlimited Prepaid Hotspot Plan

HP 2530-48G-PoEP Switch

Rasberry Pi 4 Running Pihole

Linksys Velop 3 Mesh Wifi AP's

 

Link to comment
Share on other sites

Link to post
Share on other sites

Sorry should have mentioned. Windows 10, Office 365 64-bit

CPU: i5-4690K @ 3.5GHz || MoBo: Asus H81M-C || RAM: 16gb Kingston HyperX Blue || Cooler: Stock intel cooler || GPU: Palit GTX 1050 || PSU: Can't remember exactly but know it meets the needs of my components || Case: White Falcon Case || SSD: Kingston 120GB || Storage: WD Blue 1TB

Link to comment
Share on other sites

Link to post
Share on other sites

12 minutes ago, eth_jones said:

 

Might just be windows being windows.

 

Can you open the file in Open Officer/Libre office?

I edit my posts a lot, Twitter is @LordStreetguru just don't ask PC questions there mostly...
 

Spoiler

 

What is your budget/country for your new PC?

 

what monitor resolution/refresh rate?

 

What games or other software do you need to run?

 

 

Link to comment
Share on other sites

Link to post
Share on other sites

Have you tried to open it in protected view it could be possible the file is infected and running some sort of VBA code.

Internet Connection

My Rig: AMD Ryzen 9 3900X @ 4.3Ghz | Asus Prime X470-Pro | Corsair Vengeance RGB Pro 32 GB (4 x 8GB) DDR-4 3000Mhz OC'd @ 3400Mhz 16-20-20-38 |

EVGA RTX 2070 8GB XC Gaming OC @ 2145Mhz Boosted/ 1925Mhz Memory | WD SN750 500GB M.2 NVME | Gigabye 240GB SSD | 
XSPC EX 360mm | Corsair XC7 RGB CPU WB | EK-Vector RTX 2080 | Alphacool Eisbecher D5 150mm Plexi | XSPC Fittings | XSPC FLX Clear 7/16" ID, 5/8" OD |
Corsair LL120 x6 | Corsair RM750x White 2018 | Corsair Commander Pro | Corsair Obsidian 500D RGB SE | Corsair RGB LED Lighting PRO Expansion |
Corsair Strafe RGB MK.2 | Corsair Ironclaw RGB Wireless 18,000DPI | Acer 32" 4K 60Hz HDR600 Cert. ET322QK CBMIIPZX |

Passmark Score

3dmark Score

PC Parts Picker Link to Build

Network

Netgear LBR20 LTE Router | Verizon Unlimited Prepaid Hotspot Plan

HP 2530-48G-PoEP Switch

Rasberry Pi 4 Running Pihole

Linksys Velop 3 Mesh Wifi AP's

 

Link to comment
Share on other sites

Link to post
Share on other sites

1 minute ago, Streetguru said:

Might just be windows being windows.

 

Can you open the file in Open Officer/Libre office?

We can open the file in Windows, but when we change a cell, and it has to recalculate, that's when the problems start. Sorry, should have mentioned that originally

CPU: i5-4690K @ 3.5GHz || MoBo: Asus H81M-C || RAM: 16gb Kingston HyperX Blue || Cooler: Stock intel cooler || GPU: Palit GTX 1050 || PSU: Can't remember exactly but know it meets the needs of my components || Case: White Falcon Case || SSD: Kingston 120GB || Storage: WD Blue 1TB

Link to comment
Share on other sites

Link to post
Share on other sites

7 minutes ago, eth_jones said:

We can open the file in Windows, but when we change a cell, and it has to recalculate, that's when the problems start. Sorry, should have mentioned that originally

Try some of these https://windowsreport.com/high-cpu-excel/

Internet Connection

My Rig: AMD Ryzen 9 3900X @ 4.3Ghz | Asus Prime X470-Pro | Corsair Vengeance RGB Pro 32 GB (4 x 8GB) DDR-4 3000Mhz OC'd @ 3400Mhz 16-20-20-38 |

EVGA RTX 2070 8GB XC Gaming OC @ 2145Mhz Boosted/ 1925Mhz Memory | WD SN750 500GB M.2 NVME | Gigabye 240GB SSD | 
XSPC EX 360mm | Corsair XC7 RGB CPU WB | EK-Vector RTX 2080 | Alphacool Eisbecher D5 150mm Plexi | XSPC Fittings | XSPC FLX Clear 7/16" ID, 5/8" OD |
Corsair LL120 x6 | Corsair RM750x White 2018 | Corsair Commander Pro | Corsair Obsidian 500D RGB SE | Corsair RGB LED Lighting PRO Expansion |
Corsair Strafe RGB MK.2 | Corsair Ironclaw RGB Wireless 18,000DPI | Acer 32" 4K 60Hz HDR600 Cert. ET322QK CBMIIPZX |

Passmark Score

3dmark Score

PC Parts Picker Link to Build

Network

Netgear LBR20 LTE Router | Verizon Unlimited Prepaid Hotspot Plan

HP 2530-48G-PoEP Switch

Rasberry Pi 4 Running Pihole

Linksys Velop 3 Mesh Wifi AP's

 

Link to comment
Share on other sites

Link to post
Share on other sites

check your formula on all sheet. can you share just 1 row of your file? just put any dummy data on it. I just want to check what formulas you are using.

Ryzen 5 1600 | Gigabyte GA-AB350M-Gaming 3 | Team Elite TForce Delta RGB 2x8 16GB 3200mhz | Gigabyte GTX 1060 6GB AORUS | Fractal Design Arc Mini R2 | 2 1TB WD Blue | Wester Digital Blue 3D NAND 500GB | SeaSonic M12II 520W 80+ Bronze | CoolerMaster Hyper 212 Led Turbo | ASUS VG248QE | Rakk Kimat XT | Logitech G502 HERO | Massdrop x AKG M220 Pro | V8 Soundcard | BM800 Condenser Mic | Logitech C310

Link to comment
Share on other sites

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×