lag

Good day. I have this formula for conditional formatting: =AND(AN$6=1,$AN$8:$BV$374<>"",$AN$7:$BV$374<$BX7) It strikes through the text if the conditionals are met... but the scrolling of this sheet takes a nose dive the moment I use it. How can I correct this? Should it be done in VBA instead?

I think this is a common(ish) problem. I'm running an AHK macro that copies a series of contiguous and non contiguous cells. The data copied gets loaded into some variables and later pasted into a webform. This works fine - once. I can copy and paste all of my data in one go successfully once...

Hi, I'm using Excel 2016 64bit on Win10. I have a 195Mb workbook, 7 sheets. Set to manual recalc and the book calcs in 2-3 seconds which is fine. My issue is that enter entering a value in one of the 50 or so input cells (all on sheet1), excel is typically unresponsive for up to 20 seconds...

Any idea why these lines of code would be causing my computer to lag and the excel sheet to freeze when closing the sheet? Private Sub Workbook_BeforeClose(Cancel As Boolean) Dim f As Long Dim j As Integer For f = 1 To Rows.Count If Cells(f, 1).Interior.ColorIndex = 37 Then...

All, [Using Win10 and Office 365 Business (Excel 2016?). I don't have any other versions of Office/Excel installed.] When I'm editing a form's property, like Caption, when I use the backspace key (to delete values), there is a very noticeable lag/delay for each key stroke. If I use the Delete...

I have a relatively large (8MB) workbook that pulls in tick-by-tick stock market data (hundreds of symbols at a time) via DDE API and runs a ton of formulas. I've optimized it as much as I can (no dynamic formulas, hardcoding wherever possible) and performance is passable but not great (3-5...

Hello everyone, Is there any possible way to prevent input lag in a combobox? I am currently playing around two combobox and whenever I change the value of combobox1 from Item 1 to Item 2 (vice versa) then select combobox2, I notice that the previous value of combobox1 one goes back to the...

Hi, Calling all Excel geniuses, I’m working on a project for a friend, I’m already way beyond my comfort zone in Excel, and am have an issue that I can’t get around. My project involves making a sheet that acts like a form with each row being a series of dropdown menu’s (to limit the users...

Hi All I am using Excel for Mac 15.4.1 I have a column with a lot of conditional formatting. If I type a 3 digit number in that column and hit enter, only 1 digit is entered because of lag. I have to pause between digits for it to enter properly. If I delete all the conditional formatting and...

I'm pulling in a few hundred real-time stock quotes at once and automatically performing a bunch of sorting and modeling as the data updates, but it often lags badly so that I'm sometimes seeing stale stock quotes (30-60s after they change). I've determined that it's not the real-time quotes...

Hello all, I have this code that takes info from a cell and puts it in comments, but when it does, excel always needs to restart as a result of the systems resources getting used it and causing major lag. I was wondering if anybody could give me insight into what exactly causes this, and if...

My file's not large in absolute terms (2MB), but has a dozen worksheets, several thousand formulas, a bunch of VBA macros I run, and on top of that is pulling in real-time tick-by-tick stock market data via DDE. This results in a lot of lag, and occasional crashes. (In the lower-right of the...

Hi There. Is there a way to prevent excel from loading and displaying charts on worksheets and tabs when the file is opened? We have charts that plot many data points and opening the file can be lengthy when you wait for the chart to load. Also, when you scroll through a sheet it pauses at the...

hi im trying to do a multiple regression analysis with lagged variables but everything i try excel says i need the same amount of x and y ranges. example A B C D RGDP RGDP-1 RGDP-1^2 RGDP-1^3 1 2 1 1 1...

Hi guys, This is my issue. For 6 months I have been working on an excel document (3500 rows, 100 columns) in excel 2010. Every month I have been sending it to my colleagues who then use it. My colleagues tell me that the most recent version has been met with slow opening speeds, lag between...

Hi, I've been getting a message when I'm moving around in excel and it's starting to get annoying. In the lower right corner i'm getting a message that says 'Calculating (2 Processor(s)): ??% it's counting through the ?? as a percentage, but it's taking a while. An example of what it's doing...