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

[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

 

[Nick Hodge]

Holobeat

I would be suspicious of your code in the selection change or similar,
perhaps you could give us an idea of the event code you are using. Do you
turn the events off in your event code and then back on again, for example?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[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

 

[Nick Hodge]

holobeat

Perhaps try running Rob Bovey's code cleaner over the xla code and see if is
at issue. It is surprising what junk gets built up in VBA over time
(www.appspro.com)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk

 

[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.