Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2013 - Processor overheats when processing large files

28 Sep 2014   #1
JuanBonnett69

Windows 8.1 64Bit Pro
 
 
Excel 2013 - Processor overheats when processing large files

Hello, I have a very rare issue here.

I'm trying to convert a normal xlsx file into a csv file.

In the xlsx file there are normal columns and rows, nothing strange, nor formatting or something pretty, only colums and rows with products plain information.

I've received these files via email, I've downloaded them and when I open them they open in protected mode, or view-only mode.

Each files have thousands of rows, let's say 3000 to 5000 rows.

When I click on "enable editing" button, the processor starts working at 99% it takes stays one minute frozen, and starts overheathing untill it reaches the temperature of emergency shutdown.

The problem is not the processor itself, I've made maintenance to the computer recently, removed all the dust, I've changed the cooling creme, I've played heavy video games for weeks with no problem and none of them make the processor reach more than 50șC (Excel exceeds the max temperature of 61șC).

My processor is a six core AMD FX6100, I have 8B of RAM DDR3 and the file is stored in a 160GB SATA hard drive.

Any advice? I won't be able to work with this important files unless this is fixed. Thank you


My System SpecsSystem Spec
.
28 Sep 2014   #2
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Would it be possible to do the conversion in smaller batches, rather than trying the whole lot at once.

I see you are using Windows 8, so it might be worthwhile posting on the Windows 8 Forum as well.
My System SpecsSystem Spec
28 Sep 2014   #3
Tookeri

Windows 7 Pro 32
 
 

5000 rows isn't that much so I don't think that should be the problem. Is this happening if you only open one file?

When you enable editing you leave the protected view. So I guess there's more content in these files than you're able to see in protected view, and that content may be causing this. Try on another PC to see if that gets the same problem. While in protected view you can try and copy the data to a new excel file and do your work from there.
My System SpecsSystem Spec
.

29 Sep 2014   #4
JuanBonnett69

Windows 8.1 64Bit Pro
 
 

Thank you all for your reply.

I've opened the file in a customer's computer. It's a dual core I guess, and it takes some times to open the file. Excel shows in a green bar in the bottom of the spreadsheet something like "Using 2 processors | 50%". Stays there for a few time and then, the file is ready and available to do anything.

I've had to open the files in another computer, saved them in the format I need (CSV), and then sent these files via email. When I open the CSV files in my computer, I can work with them normally.

It's a weird issue, I don't know if someone else has had this too. There must be a huge amount of factors that could be causing this.

EDIT:

I realized the XLSX file I opened had more than 38,000 Rows.

When I open that file (it's 3MB) it opens fast and normal but in protected view. I can see all the rows.

When I click on "Enable Editing" is where my processor goes insane and starts heating to the maximum temperature of 61șC, if that temp is exceeded, the system shuts down automatically.

My customer has these files on his computer, and when he opens them he does not have this problem. Weird.
My System SpecsSystem Spec
29 Sep 2014   #5
Tookeri

Windows 7 Pro 32
 
 

Good that you could work around it

My guess it's the content in these specific files that does some heavy work when they're opened. But when opened in protected view that isn't allowed as everything is read-only.
My System SpecsSystem Spec
29 Sep 2014   #6
JuanBonnett69

Windows 8.1 64Bit Pro
 
 

I'm about to think it is an MS Excel 2013 bug. It just goes insane, I'll try to figure out if my office is up to date and then I'll check again.

It might be a bug in terms of processor management when Excel is doing it's math and processing each row.

How is it possible that all the cores in the processor reach 100% in usage and it reaches the overheat temperature in few seconds? o.0
My System SpecsSystem Spec
29 Sep 2014   #7
Tookeri

Windows 7 Pro 32
 
 

I get lots of hits when google: excel 2013 cpu 100

You could try Excel in Safe Mode by holding down the CTRL key when starting Excel: Work with Office safe modes - Excel

Or do a repair install of Office.
My System SpecsSystem Spec
29 Sep 2014   #8
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

To see if your Office 2013 is up to date, open an Office application, click on File & then select Account, this will show a box called Office Updates, click on that & select Update Now. This will update your Office 2013 if needed or tell you it's up to date.
You could also try repairing Office. Open Control Panel, select programs & Features, scroll down to Microsoft Office, Right Click on it & select Change & this will open a couple of repair options to try.
My System SpecsSystem Spec
Reply

 Excel 2013 - Processor overheats when processing large files




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Processor @3.3GHz when idle => overheats
Hello, when my processor is idle it runs at 800MHz. Every now and then, the processor speed suddenly goes up to max speed (2.4GHz or 3.3GHz turbo) for no reason. It produces a lot of heat which makes the fans go wild. I haven't found any background processes that might use the processor without...
Performance & Maintenance
extra large bottom row in excel 2010
I've noticed this on only one of my excel spreadsheets. Sometimes, not always, when I open this file, the bottom row on one of the pages takes up the whole monitor viewing area. If there is- for example- 400 lines of data, the next line down won't have a number on the left. If I highlight this...
Microsoft Office
Excel 2013 - how to keep a formula consisten
Hi I am trying to tie one cell into a formula that is being pasted into multiple rows. I know you can use $ to keep the cell consistent but it doesn't seem to be working. So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the...
Microsoft Office
Error on saving MS Office Excel 2007 files to MS Office 2013
We have an upgrade on our computer units here in the company, my problem is when users save their 2007 excel files an error pops up, Errors were detected while saving "File Name". Microsoft maybe able to save the file by removing or repairing some features. To make the repairs in new file, click...
Microsoft Office
Excel 2013 Won't Automatically Open Files
I am running into a bizarre problem with Excel 2013 and I can't seem to figure out the cause - searching around I couldn't find a solution, either. I have both Office 2010 64-bit and Office 365 (2013) 64-bit installed on my Windows 7 system. The only reason I still need 2010 is that 2013's...
Software
Batch processing (xlsx to xlsb) in Excel 2010
Hello! I need to convert xlsx-files to xlsb-files. I've found some tools on the internet, which are able to do that, but only if all the xlsx-files are in one folder. My folder topology looks like this: main folder -> containing 44 folders -> each of them containing 1-3 specific folders ->...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 19:25.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App