We work on a product that uses Excel, we are now testing all aspects of Excel 2013. During these tests, we seem to have encountered a problem where excel suddenly causes high CPU usage by only drawing some shapes. We have been able to minimize the problem into the following few steps: Open a new, clean workbook Draw an oval, give it a material (right-click, choose “Format Shape”, click “Effects”, “3D Format”, “Material”. Choose any material.) Duplicate the Shape four times, producing Oval2, 3, 4 and 5. Group Oval2 and 3. Group Oval 4 and 5. Press Alt-F10, in the selection window, hide the group containing Oval2 and 3. Deselect everything (!) by clicking in an empty cell. Now observe the task manager. On an I7 Windows 7 PC, Excel now runs 4 cores at around 50%. Also, OnTime functions are not being called anymore because of this rendering bug. Once you select any shape, or un-hide the hidden group, Excel becomes quiet once again. Also, the problem can be prevented from happening by removing the materials in the shapes. This bug (?) seems to happen also on most of our more complicated applications, and it would take lots of work to re-design everything not to use materials. Can anyone confirm this problem, provide a workaround?

Hi Try disabling add-Ins Hello, CPU High Usage is still prevailing on my computer, though tried the steps from above.

Hi, I think I have found a work around. I had this problem all of a sudden. I copy a row and Excel 2013 hang for about 20 sec. The file I open is a file reciding on a sharepoint site in a MS cloud 365. I saved the same file to my local disk, reopend it and it works like a charm. No problems what so ever doing the exact same manouver I did just 10 min ago. I now copy the file from my local drive to the same Sharepoint with another name, reopen it, do the exact same trick with copy/paste and it works like it should. I have no idea if this is fluke or if it has something to do with networking and/or Sharepoint. Hope this helps. Kind regards Jari ************** Feed back ***************** Now my Excel behaves as before again. Explanation above is not working.

Hello Matis, Welcome to Microsoft Community and thank you for posting your query. What are the troubleshooting steps you have tried? Let’s disable hardware acceleration by following the steps below and verify the status. · Open the Excel program. · Click on file , Options. · Go to the Advanced tab. · Under the Display section, check the box for 'Disable hardware graphics acceleration'. · Click OK. I hope the above information helps. Let us know if you need further assistance. Thank you.

Disabling Hardware graphic acceleration (and disbaling any other option for that matter - trust me I've tried everything ) only prevents freezing, but does not prevent cpu spikes. I've just tested copy and paste with a simple excel file that represents the problem perfectly: Ctrl+C a couple of cells -> CPU climbs to 60% (This on a machine with an i7 and 12 gigs of ram) Esc -> CPU drops to near 0. Clearly excel's clipboard is doing some pretty intensive calculations when copying cells. What its trying to calculate god only knows...

Excel 2013 High CPU Usage

Anonymous

We work on a product that uses Excel, we are now testing all aspects of Excel 2013. During these tests, we seem to have encountered a problem where excel suddenly causes high CPU usage by only drawing some shapes. We have been able to minimize the problem into the following few steps:

Open a new, clean workbook
Draw an oval, give it a material (right-click, choose “Format Shape”, click “Effects”, “3D Format”, “Material”. Choose any material.)
Duplicate the Shape four times, producing Oval2, 3, 4 and 5.
Group Oval2 and 3. Group Oval 4 and 5.
Press Alt-F10, in the selection window, hide the group containing Oval2 and 3.
Deselect everything (!) by clicking in an empty cell.

Now observe the task manager. On an I7 Windows 7 PC, Excel now runs 4 cores at around 50%. Also, OnTime functions are not being called anymore because of this rendering bug. Once you select any shape, or un-hide the hidden group, Excel becomes quiet once again. Also, the problem can be prevented from happening by removing the materials in the shapes.

This bug (?) seems to happen also on most of our more complicated applications, and it would take lots of work to re-design everything not to use materials. Can anyone confirm this problem, provide a workaround?

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

86 answers

Anonymous

2015-04-06T07:19:34+00:00

Hi

Try disabling add-Ins
Was this answer helpful?

0 comments No comments
Anonymous

2015-04-09T01:20:32+00:00

Hi

Try disabling add-Ins

Hello,

CPU High Usage is still prevailing on my computer, though tried the steps from above.
Was this answer helpful?

0 comments No comments
Anonymous

2015-04-15T14:27:39+00:00

Hi,

I think I have found a work around.

I had this problem all of a sudden.

I copy a row and Excel 2013 hang for about 20 sec.

The file I open is a file reciding on a sharepoint site in a MS cloud 365.

I saved the same file to my local disk, reopend it and it works like a charm. No problems what so ever doing the exact same manouver I did just 10 min ago.

I now copy the file from my local drive to the same Sharepoint with another name, reopen it, do the exact same trick with copy/paste and it works like it should.

I have no idea if this is fluke or if it has something to do with networking and/or Sharepoint.

Hope this helps.

Kind regards

Jari

************** Feed back *****************

Now my Excel behaves as before again. Explanation above is not working.
Was this answer helpful?

0 comments No comments
Anonymous

2015-04-16T08:26:50+00:00

Hello Matis,

Welcome to Microsoft Community and thank you for posting your query.

What are the troubleshooting steps you have tried?

Let’s disable hardware acceleration by following the steps below and verify the status.

· Open the Excel program.

· Click on file, Options.

· Go to the Advanced tab.

· Under the Display section, check the box for 'Disable hardware graphics acceleration'.

· Click OK.

I hope the above information helps. Let us know if you need further assistance.

Thank you.
Was this answer helpful?

0 comments No comments
Anonymous

2015-04-29T19:05:58+00:00

Disabling Hardware graphic acceleration (and disbaling any other option for that matter - trust me I've tried everything ) only prevents freezing, but does not prevent cpu spikes. I've just tested copy and paste with a simple excel file that represents the problem perfectly:

Ctrl+C a couple of cells -> CPU climbs to 60% (This on a machine with an i7 and 12 gigs of ram)

Esc -> CPU drops to near 0.

Clearly excel's clipboard is doing some pretty intensive calculations when copying cells. What its trying to calculate god only knows...
Was this answer helpful?

0 comments No comments