slow down

  1. M

    InputBox is slowing down my code

    Hello Given a selection, I want to copy the cells fills of it to another part of the sheet I have a macro that stores the cell fill colors and patterns of a selected range in arrays. Then the arrays data are used to paint the cells of another zone This macro takes about a second to run But...
  2. D

    Slowdown from Named Ranges in xlsm format?

    Hello, I have a client who as an Excel project that spans 10 workbooks. The reason for this is that it was created in the early days of Excel and it was deemed better to split the project up so file sizes would be more manageable. (sizes are 165KB to 3.5MB) These 10 workbooks are linked to...
  3. S

    Can one have to many DAX formulas?

    I'm wondering if having about 100 DAX measures could slow down my system. My file is about 95mb, SQL connection to our retail management system 4.7gb. But it seems to be getting slower. When i refresh now it's about 15-20 to update daily. Any thoughts? Suggestions on speeding it up? Things to...
  4. littlepete

    Excel element that slow down working

    hello i have a general question about things that slow down working on excel : 1. i noticed that a column with numbers (2000 rows) and conditional formatting on each of those numbers, depending on some conditions, slow down the whole excel filtering jobs ! (dramatically) 2. adding a formula...

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