 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / August 2008Excel 2007: Flickering formula bar after data entry + CPU up to 50
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 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?  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk > When I enter a value into a cell and hit enter, formula bar starts > flickering [quoted text clipped - 11 lines] > > 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 > Holobeat > [quoted text clipped - 17 lines] > > > > Holobeat 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) SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk > Nick, > [quoted text clipped - 36 lines] >> > >> > Holobeat 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.