slow calculation

I have a spreadsheet that is used to manage the annual budget along with monthly forecast, monthly resource costs, vacations etc. in separate sheets in the same workbook. So needless to say there are lots of formulas in these sheets and references across sheets. I am also using named ranges and...

I created a large file which acts as a master database, which holds some helper columns with calculations (12Mb). When I activate the calculation manually, it takes ages until completed. It starts by jumping to about 82% and then it stops for more than 10 minutes. I have tried to follow advice I...

I'll start with my question, first. What operations tend to bog excel down, and how can I speed up handling of very large data sets? My circumstances are as follows: I have several sheets, each of which are upward of 10K rows and 20 columns, but one of which is over 60K rows. These are...

Okay so I kind of know why its slow and I will explain but, I'm hoping there is a kind soul out there who can help me make it less so. So in regards to what my code actually does. When values in 3 adjacent cells in columns C,D and E are entered, the date of entry is recorded in a separate sheet...

I have an excel file which is running painfully slow. I believe the issues are where I have used the Xlookup and Sumifs formulas. Does anyone have any suggestions on how to speed this up? I am open to using visual basic if needed. You can download the file at the link below. The two tabs where...

Hi, I have the below base data that I want to split in to individual sheets. So that each ID has its own sheet. ID heading is in cell A1 ID Name Detail Date 1A Joe Arm procedure 24-Mar 2A David Leg procedure 12-Feb 3A Sarah Shoulder injection 01-Apr 1B Hannah Knee Pain 03-Feb 2B...

Hi all, My workbook is getting very slow, especially when i insert rows or enter new data for example. Is there a faster way to achieve the same result? I hope the formulas are translated correctly from dutch to english. Formula 1...

Dear forum, I'm looking for a clean and light way to transform the way my data is stated. I succeeded in writing a code to stack several columns on top of another, running from the first row downwards to the first blank cell and jumping to the next column. As is shown in the table below, the...

I have a dataset consisting of approx 200,000 rows. One of the columns is named ProjectNumber, and if I remove the duplicates there is approx 2,000 unique values left. I have a lookup formula to another table with projects, to check if the ProjectNumber exists. I know how to do the lookup...

Hi folks! The following VBA code is applied to a single worksheet, it triggers and email send (via Outlook) when a cell in a row becomes "Overdue". It actually works fine, however I've noticed upon opening the workbook it takes an AGE to calculate and then allow me to modify the worksheets...

I have a file where one second the entire workbook only takes a couple seconds to calculate everything, but every now and then it will suddenly take an unreal amount of time to process, and will continue doing this. I have played around with this and it will happen without any changes to the...

Hi, I've created a worksheet that has the following array index formula: =IFERROR(INDEX('True Prelims'!$B:$I,SMALL(IF('True Prelims'!$I:$I=Table!$A$1,ROW('True Prelims'!$I:$I)),ROW('True Prelims'!2:2)),1),"") Basically it works but is awfully slow when run on VBA and I was wondering if anyone...

Hi people! I am trying to make vlookup faster, but it isn't going as expected. The problem is maybe that there are 400k records in base sheet and 20k in final sheet. Is there any faster way, maybe not vlookup, maybe not even vba, to get this done faster? Thanks in advance. Here is my code...

Hi There. I am running the code shown below and it is going incredibly slow. When I manually run the code (pressing F8) I notice there is a long pause when the Cell length = 6 between the lines ' Cell = MyLeft & ".00" ' and the 'End If' statement. Can anyone see why? Does the size of the file...

I have a code that works very quickly when it finds a value in a large spreadsheet. If it does not find the value it takes a couple seconds to register. Anyway I can speed it up? This program has a list of values on one sheet and takes each value to see if it is in another sheet. If found it...

Hi everyone! Thanks for checking into my issue and I appreciate any responses I'll get. I have a database that has thousands of cells that I need to find/replace monthly because the formula needs to reference the correct month's data folder from another workbook every month. My issue is that...

Hi everyone-- I have a worksheet that is split into months columns (January, Feb, etc...) and I have about 10 different tests with 10 test questions listed down the rows...basically I have 100 or so cells that need updating month to month. All of these cells are pulling data from a shared drive...

Hi, I have a large excel file of golf results (150,000 rows) and I have a vlookup formula that will look though the results and tell me what position the golfer came in previous years when playing on that course. However the vlookup formula I use takes forever to calculate and seem to be...

Hello, I am currently developing a basic monte carlo simulation for planning, based on a beta distribution. I have 12 worksheets, each with up to 20 columns - one for each different scenario (different max, mode, min variables), with each scenario being modelled for 2000 events (i.e. 2000...