slow

Hello, I have a spreadsheet which has 60,000 rows, calculations on every line over many columns. Using Index/Match a lot of the time, makes the spreadsheet very slow and large, are there any alternatives; or maybe someone could suggest a different approach? Many thanks.

Hi, I'm building a stock management system, and I need a formula that looks through a range of codes on each worksheet in a workbook. It adds the number in a specified column on the same row, and brings the sum of these numbers back to a summary page. Basically it adds up total usage of...

I have an Excel Spreadsheet built with 500 rows (Locations) beginning on Row 4 and ending on Row 504. There are Summations under it as well as Summary Tables. The User is able to select the number of Locations they require for the specific job, as long as it's not more than 500. If less than...

Functionally, this is working and doing what I need: ={SUM(COUNTIF(B:AO,B1:AO1))} It's just really slow because I have 9000 rows and this is being dragged down. It would probably take hours to calculate. I'm assuming it's slow because it's taking empty cells into account as in general, only...

Hiya peeps. I am trying to find a way to return all results from something similar to a Vlookup froma huge list and return all the results into a single cell, eg concatenated. I have tried the LookupConcat UDF and is made the sheet go horribly slow, so looking for an alternative formula or...

Hi , Am using the below vlookup formula but it taking very much time to apply and filtering the values. Is that any other of formula to make it faster than this. Range("C2").Select ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Output!C[-1],1,0)" Range("D2").Select ActiveCell.FormulaR1C1 =...

Hi everybody, Through trial-and-error, I have determined that the following section of my larger code is causing my overall macro to run really slowly: Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False Application.EnableEvents...

Here's the code: For i = 5 To 173 Step 7 Sheets("Data Sheet").Select Columns("D:G").Select Selection.AutoFilter Sheets("Data Sheet").Range("D:G").AutoFilter Field:=4, Criteria1:="HBsAg" Sheets("Data Sheet").Range("D:G").AutoFilter Field:=1...

Hi everyone. Does anyone have any idea how I can bypass the problem of using an array formula when I use the trimmean with criteria? The excel is already extremely slow and the array just blocks it completely Thanks, Rui

I know this is an Excel forum but I don't where else to turn. My computer is running rather slow, does anyone know of any free software that is virus free that will help speed up my computer performance. My excel files are taking forever to load and I don't have any programs open other than one...

Hello, I have been developing an excel model that has become a bit slow in running certain calculations. This is a 10 tab model without anything too complex, and I was wondering if anyone with experience would be able to help me optimize this model so that is runs a bit quicker. I would be...

Hi everyone I have an excel spreadsheet that is linked to a SharePoint list. When I open the excel file, the source data goes to the SharePoint list and updates the data. I then use this data and built 8 pivot tables for various purposes. Due to the filtering and grouping requirements, I...

I have a workbook that takes a half hour to start. I have looked high and low and can't seem to get it to load any faster. Anybody have knowledge of any utilities I can use to track what is taking so long? It has 13 sheets in it and 7 external connections, primarily to SharePoint sites (.mht...

Hi all, I have a big excel file with over 20 sheets, each with a large amount of formulae. As it takes too long to open the worksheet, calculate the formulae and even saving the file, I've devised a VBA code to perform the formulae of each worksheet in a macro. Annoyingly this macro takes too...

All I'm trying to achieve here is to look at 2 data extracts (this weeks against last weeks) and highlight any deltas... SO, what is on this weeks file that wasn't on last weeks - As they'll need creating/loading and, what's on last weeks file that isn't on this weeks - As they'll need...

I have a very long code that does exactly what I need it to do, except it takes 25 seconds to run. I have narrowed it down to the following two sections of code that are slowing it down. Can anyone help me on how to make these run faster? First Section: lastrow = Sheets("Crew...

I have a workbook that contains this macro which basically takes a raw export on one sheet and then pastes it into an existing table and inputs the formulas that are in the columns that are calculated. Then the rows blank in row E are called to be deleted through the second sub macro. This locks...

Hi Everyone, I have this code below, but it is running extremely slow, by my calculations it would take 3 days to complete one sheet. Do you perhaps have suggestions on how to speed it up, as I have more than 100 sheets to get through please. Sub Calculate_Sheet() Dim orderSh As...

Hi all, I am trying to run a macro to delete all the "..." in my excel document. I have tried to do this two ways, both by looping, and with special cells. Depending on the data, this is taking upwards of an hour. Does anyone have any reccommendations on how I can improve this. The data, does...