speed

  1. A

    Power BI Performance

    Hello Everybody, I am seeking for answer about Performance of Power BI. Originally I had 2GB Access database, converted into Power BI, with some other small tables it give me 130MB PBIX. After creating the model I realized it is too slow, does not pass "3 sec" test. I did following steps: 1...
  2. Gingertrees

    Speed question: which is faster: loop to add formula, or fill-down?

    I currently have a macro set up that loops through used rows to add a different formula to column A, B, C, D, and E. So it applies the formula to A3, then another formula to B3, etc. to E3. Then it loops and does the same to A4, B4, etc. to the end of range. Is this the fastest way, or would...
  3. F

    How to speed up index match function

    I have this line of codes however , my excel will lag and most of the time it will stop responding . Why? :( Cross Ref: How to speed up this index match function Any suggestion ? Private Sub Unsuccessful() 'Update Column S and T 'S = Active Ext ID , T = Inactive Ext ID Dim MaxRowNum As Long...
  4. J

    Simple Macro, Slow Calculation. Help speed up please

    I have a very simple command button that adds 1 to a cell like a tally. Dim whiteBloodCell As Integer whiteBloodCell = Range("E10").Value + 1 Range("E10").Select ActiveCell.FormulaR1C1 = whiteBloodCell The problem I have is that lets say I see 2 white blood cells. I want to double click the...
  5. P

    transpose 250K rows then AutoFill 250K/3 rows bogs down excel

    Hi There I appreciate your insight on this. Problem starts at step 1. Then 2. …so on, excerpts below. Is a pivot table more efficient than transpose? What about the rest of the code? It keeps getting slower and never finishes in 1 hr. Task manager shows excel pegged at 13% cpu and 3.25GB...
  6. L

    What is the fastest way to consolidate data into one usable source...

    I love this forum. I used to post here all the time and I can honestly say that the help I have gotten from people here has helped me become an OK Excel user. So I have another question and I'm wondering what you all think might be the best way to accomplish this. I have a workbook which...
  7. W

    Help with vba code to find a number how many times repeated

    Hallo Guys, I am working on analysing data for over 277 sheets with different datas. What I am searching for is to find how many times is this number which is greater or eqaul to a number and less than another number repeated. For example a number : 0<= number <4 I attached example worksheet...
  8. R

    Macro is slow, is there a way to speed it up?

    Hello, My macro works but can take up to 5 minutes or more to finish up. Is there a better way to do what I have below? The table creation goes quickly it is when it goes through it to delete what it doesn't need that slows it down. I am using excel 2013, and most of my experience with vba...
  9. A

    Need help with macro

    I've created a Macro that will copy what's in cells and then insert that X amount of times in the cells below(Being used to copy formulas). However, the macro takes far too long to run, rendering it impractical. Could someone please assist in optimising my code so that it can run a bit quicker...
  10. H

    Speed of worksheet functions

    why does worksheetfunction.acos(c) take about 10 times the time of the atn( sqr(1-c*c)/c)) method :eeek::eeek:
  11. A

    Can this For Each Next loop be restructured to make the execution faster

    Hi everyone, Below is a portion of code from a sub from a large worksheet table (~75000 rows A:BB columns). I currently select a range manually, then run the sub. For Each cell In rng cell.Formula = "=concatif([Material Number],[@[Material...
  12. J

    VBA Speed of Sub vs. Function when not returning a value?

    Hi, I know that we rather use a Sub than a Function when we do not return a value from a procedure. However, here is a case whereby all the code in a Module (even when not returning a value) has been written with Functions instead of Subs. Before changing everything (quite a task), I wonder...
  13. J

    Slow VBA Code

    Hi Forum, I am creating a macro to turn raw data into a condensed form, the rest of macro is super quick but this particular part is not, Can anyone please recommend a way to make this formula quicker...
  14. Y

    Why does my spreadsheet process so slowly?

    Hi everyone, Here is a link for my spreadsheet. Hope you can download it. The query itself doesnt run too slow but the excel spreadsheet as a whole is slow. Can't scroll fast enough, make selections fast enough etc. This occurs even if it is the only file that is open...
  15. J

    VBA Speed-Up Ideas

    Hi All, I'm still quite new to programming and so don't know all the tips and tricks. Here is some code I have written to summaries customer purchase information. If you can see anything I can change to speed it up it would be much appreciated... Its pretty long and taken me ages to do, but...
  16. B

    VBA code - Complicated script that takes forever - Please help me make it smoother

    Dear Brilliant forum I have just received a work related task. I have little knowledge of VBA, however, I told my colleagues that this forum has the best Excel/VBA brains out there. I received a document containing our product sales and an attached macro that sorts these products (and inserts...
  17. P

    Power query speed

    Hello All, I have a question regarding the speed of loading data into Power Query. Currently, I have a folder containing 10 .CSV files (each ~300MB in size). Loading this entire folder into Power Query is very convenient but after about the 2 millionth row the speed drops to the tune of ~2,000...
  18. A

    Which bad practices/operations greatly slow down VBA macros?

    Hello I've been writing long, computationally expensive macros lately, and have noticed that VBA is considerably slower at certain types of computations than others. Copying/pasting, debug.prints, and Application.ScreenUpdating = True are some expensive operations that stand out to me. I was...
  19. S

    Performance Question

    I have a large data set of about 375,000 rows by about 6 columns and I have a macro that does a few calculations on the dataset and appends two additional columns for each row. The calculations are pretty mild (basic division, multiplication and a sqrt function). Ultimately, the macro works as...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top