1. N

    Bad performance updating Pivottables

    I have created below model. Sales-data containes 600K rows, Dcalender 750 rows, Item info 1700 rows, Customer info 2000 rows, and remaining dimension tables app 25 rows. 2 calculated columns in DCalender, all other calculations have been created with DAX measures or M language custom columns. I...
  2. B

    Using Excel in virtual machine (virtualization, performance, benchmarks, overall usability)

    Hi, all! I'd like to get the best possible freeware virtual machine (VM) for Excel 2010 or 2013. 1st criterion is performance, 2nd criterion is overall usability. I've done a little research and tried VMware Workstation 16 and Oracle VM VirtualBox. VMware beats Oracle on my machine in terms of...
  3. A

    Sumx Performance Issue

    Hey all, I'm having some performance issues with Sumx that are causing very slow measure performance as was wondering if you smart people would know of a better way to accomplish these TestMeasure= 'Take the slicer selection date' VAR CalculationDate= [SelectedDate] 'Calculate USD values...
  4. S

    Defined Names - Excel Performance

    Hi, I would like to use Defined Names more prevalently in my Excel files. This comment directly below taken from has given me pause for thought. "Defined Names are recalculated each time a formula that directly refers to the name is recalculated" To be honest I don't quite...
  5. R

    Find empty or constant columns

    I tried this snippet in Excel/Power Query to find empty and constant columns in my table: delcols = List.Select( Table.ColumnNames(previous_step), each List.Count( List.Distinct( Table.Column(previous_step, _))) <= 1), However, when I use this with about 60...
  6. S

    Reduce time taken for VBA loop

    My VBA code currently loops for 5,000 iterations and takes about 25 minutes to collect the output data in the Output excel sheet. Is there a way to reduce the time taken for instance by improving the copying and pasting of values, collecting the output data in some kind of array etc.? Given that...
  7. dispelthemyth

    Excel performance analysis - Software

    Do you know of any software that analyses an Excel workbooks performance (i.e. calculation speed) and determines the bottlenecks, i.e. DataTables, slow formulas etc? I have a file that takes 0.5s to recalculate but i need to recalculate ~10 times and rerun dozens of times so every...
  8. K

    Helicopter Performance Chart

    OK, here it goes. I'm a helicopter pilot and in the operator's manual of the aircraft is a performance section. What I'm trying to do is take the performance charts and convert them to excel. basically its a scatter chart with different variables. In short you take the temperature match it up to...
  9. G

    SUMIFS between two different workbooks (SUMPRODUCT solution needed)

    Hi, I have recently discovered that SUMIFS only works between two different workbooks if both workbooks are open at the same time. I've also read to get round this, SUMPRODUCT can be used. That said I can't get it working. The SUMIFS version of the formula I need converting to SUMPRODUCT is...
  10. H

    Calculating The Impact of Volume and Conversion Rate Changes

    Hello everyone, I'm trying to calculate the impact three ever changing variables are having on our month on month performance. We have 10 buckets that are filled with applications and the scenario is: The total number of applications changes month on month The % of total applications that sit...
  11. M

    Examples of slow/expensive to calculate spreadsheets?

    Hi, I'm conducting a performance comparison between various versions of Excel. I'm looking for real world examples of slow or expensive to calculate sheets. If anyone knows of some examples they could share that would be great. Thanks, Mark
  12. E

    Makro Performance

    Hey friends, I have two sheets where I have the same colored cells that each have a number. On the first sheet I only want the numbers below 50 and in the other above 50. I wrote a code for a command button to do so. The one code that deletes all the numbers above 50 takes about half a second...
  13. VBE313

    How can I change this to a certain range rather than entire column?

    How can I refer to a range rather than entire column? Thanks Function Level5MakeMaterialCost() Dim R As Long Application.Volatile (True) R = Application.Caller.Row + 1 Do While Cells(R, "BN").Value <> "Yes" If Cells(R, "BM") = "" Then Exit Do Level5MakeMaterialCost =...
  14. C

    summarise one sheet and have results sent to a second worksheet

    Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I have two worksheets in the same work book for monitoring supplier performance, Sheet 1 “Supplier...
  15. C

    Consolidate on Time Delivery for each supplier and pull results into a different spread sheet

    <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> Hi, Could you please offer some advice on following? Our current accounts package sage 50, cannot calculate any on time delivery performance natively so I have to out reports to excel I...
  16. L

    Boosting the performance of Work book through VBA

    Dear all, Greetings! MY concern my excel sheet is getting with late performance, even though file is below one mb. Need VBA code to boost the performance of excel sheet.
  17. A

    Graph Help - Display multiple data

    Hi, I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example: In Category 1, Customer A had growth of 2% in the market but our business...
  18. J

    How to Find Overall +/- Percentage Performance Over Several Quarters

    I'm at a loss on this. I need to find the Overall +/- performance % of errors made over the 4 quarters of the year. I can get the performance +/- from the previous quarter but the overall is a mystery. My data is: 1st 2nd 3rd 4th 50% 67% -55% -78% Keep in mind that positive % =...
  19. N

    Need complex vba help!

    I am trying to create a tracking system for the data below. The macro will run in the first tab and track the data from the second tab. I need the macro to match the sections then look up the date from the first tab and determine which date range it falls into on the second tab. Once it has...
  20. G

    Merge Excel cells into a Word .docx

    Hi, I am trying to automate a monthly investment commentary where I would write predetermined sentences in Word with certain portions of the sentences being left blank and meant to be linked to cells in an Excel worksheet; somewhat similarly to a mail merge greetings linked to an address book...

Watch MrExcel Video

This Week's Hot Topics

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