calculation speed

Hello, I am looking for a way to improve the calculation speed in my workbook. Currently I have six macro buttons doing the same for all six departments (here D2S). Sub D2S_Button() 'Description: This macro will loop through a row and 'hide the column if the cell in row 1 of the column 'has...

Does anybody know the reason for the lag before calculation in a large workbook? And potentially how to resolve... Specifically, when I change a particular input it takes a minute to complete the calculation - during that minute I can look at the Processes tab of Task Manager in Windows and...

Is it faster to have fewer dependencies and more columns or vice versa? Thanks

I have a huge file that I'm trying to identify customers that have no volume in 2018. I want to rank by location and create tabs of the top 100 from 2017 for each location. A small example of the formulas that I'm working with is here...

Hi... I have a relatively small spreadsheet, however, it has a number of DSUM forumlas which are each looking at 20,000 rows and about 55 columns. This seems to be bogging down the calculation speed such that, even with virtually no data, the calculation time is about 30 seconds on a PC with...

Hi All Am I using the right formula? Is there a way that would speed up calculation time.:confused: I have used the formula below to return a values for different matches. There are just over 1000 different combinations. Depending on the match I need to return different 3 different categories...

Hi, I have multiple workbooks open and one of them is quite a large file with a huge amount of calculations in it. I have copied values as much as I can in the file, but the rest of the calculations are needed for choices I make as the data is dynamic. The problem/question I have is: When I...

Hi All, I'm currently working on a very large file and excel is consistently crashing on me. I believe this is largely due to the number of indirect functions I'm using. I have 31 sheets, named D1 - D31, for each day of the month. I then have a data sheet and 6 sheets analysing the monthly...

I have a pivot table with 47 fields to choose from. I'm adding these to the row section of the PT. Each time I add a field it is taking forever (calculating...). The source data is on a separate worksheet and is values-only, which I thought might help but apparently not. The source data...