Excel 2007: Flickering formula bar after data entry + CPU up to 50

H

Holobeat

When I enter a value into a cell and hit enter, formula bar starts flickering
at a high rate. At that moment, CPU on Excel process goes up to 50%. When I
add a breakpoint on Selection Changed event and change the selection on the
sheet, it stops on the breakpoint and CPU goes down to 1-5%. During the high
CPU rate on Excel process (during formula flickering), none of my procedures
in XLA file gets hit.

If you have any idea what might be causing it, please let me know.

Holobeat
 
H

Holobeat

Nick,

We actually have our addin in Excel. It is partially XLA solution. The addin
works without any issues under Excel 2003 and it works 99.9% on Excel 2007.
The addin is time tested and stable. The issue described in my post happens
rarely, and the only solution right now is to restart the Excel application.
If the formula bar starts flickering, I can still change the cell selection
and the content of the formula bar reflects the new selection (while still
flickering). None of my UDFs gets hit during this.

~holobeat
 
P

Pera

I have the same problem with my Excel add-in (xla file). I tried to clean it with CodeCleaner, but it doesn’t make any difference.
Problem occurs with Excel 2007 only (I have SP1 installed), when I create a chart.
After the chart gets created, formula bar starts to flicker and I cannot close Excel and I cannot switch to different workbook. However, I can switch between sheets in the same workbook.
Problem occurs random, there is no rule.
I tried to disable AV software, video drivers, WebCam software, … but it only lowers the number of times problem occurs, it doesn’t solve it.

Pera.
 
Top