slow

I have a large file that is about 2,000 kb in size. I am looking to add more rows in it with formulas and when I do the file slows up. The file does contain a few Macro's. I have tried saving the file as "Binary" and I even change the Calculation Options to "Manual". Even with a smaller file...

Hi, I got this formula idea from an old thread here. I successfully got the formula to work, but it's very slow. Is there a simpler process? =IF(A2="","",SUMPRODUCT(SUBTOTAL(9,OFFSET('Partner Planner'!C2,ROW('Partner Planner'!$C:$C)-ROW('Partner Planner'!C2),0)),('Partner...

Hi I have had a constant size of my database for almost a year. Now suddenly my database have become very slow. First i thought it was my network since i got the files on a server. But running some test i get 50-70 Mbps. So it should not be a slow network. However, if i put my database on my...

Hi I have recently started to have big issues with my database being slow. It is pretty much only slow in one way, when typing in textbox. I do not why this started to happen... my database is on a network drive so others can use it. It is splitted. the frontend has a size of 6mb and the...

One tab on an Excel spreadsheet is running very slowly. When I go Find & Select, Selection Pane, I can see there are at least 50 shapes, all called "AutoShape 140" (no idea where these came from). Whenever I try to delete any of these (even individually), Excel crashes. I have tried...

hello I have some external data that I import daily into a spreadsheet using VBA. The data I am given is not consistent - there are often spaces in the string in data in column 'I', and I would like to clean it up before importing. The spacing is also never consistent so I would like to make...

Hi, I am brand new to macros and need some help. I have a sheet that needs to be split into multiple sheets, based on the criteria in column E. The data changes periodically so I have to run the macro every couple of days. I need the macro to clear the contents of the target sheet (without...

I was given a modest workbook (950 kb), and asked to optimize it. Aside from a few loan amortization tables, there is not a lot of calculation going on. There are well under 5,000 rows total - across all 20-25 worksheets. But the calculation speed is VERY slow. You click "CALCULATE" in the...

Hi i have a project .xlsm file which opens in existing Excel sessoin. I use excel 2010 Problem is that if there are already open excel files, this .xslm file runs very slow. cAN I build a code within this file which will open this file in a new session only. Many thanks in advance. Regards...

Hi Guys, I m new to VBA ode and created a tool where I have code linked to a active x control button that clears certain cells in my xslm workbook. The problem I am having is the tool is running slowly once the button is clicked. Private Sub CommandButton13_Click() If MsgBox("Do you want...

I came into work yesterday, and noticed my computer acting really slow. I'm not sure if there was maintenance being done on the server, or what was going on. But in my code I manipulate IE, and use IE.Quit at the end of each sub that uses it. Well, I kept getting an error saying a system...

My workbooks contain a lot of formulas. When I have te workbooks open it causes excel to be very-very slow. I need to find a solution as it is affecting my work. Please help.

Is there an app or website to automatically search a formula and condense it if possible? I have a formula that when pasted into Google docs, takes up 14 pages. The formula runs about 75 times on my spreadsheet, and even though it functions as it should, changing a reference value makes for a...

Hi, I have a workbook which is running very slow in just one worksheet. It is almost unworkable. I cannot scroll, the page constantly freezes and occasionally the workbook crashes. When it does work I can use the other worksheets without any issue. The worksheet in question has a lot of...

We just converted 5 of 6 PCs From Excel 10 to Excel 16 and also Windows 7 to Windows 10. Both the old and new PCs are 64 bit operating systems. Most of the Excel files use code for a variety of routine tasks. There are lots of loops and fairly large files. We are running on a network, but...

Hi, I am using SUMPRODUCT to summarize the vacation days for all employees for each month. My formula looks like this: =SUMPRODUCT( ('Cal'!$A$1:$A$200=Summary!$A1)* (('Cal'!$D$4:$ND$160="VC")+ ('Cal'!$D$4:$ND$160="SK")+ ('Cal'!$D$4:$ND$160="TR")+ ('Cal'!$D$4:$ND$160="JD")+...

Hello all, Hoping someone can help with a calculation problem I have been using… =INDEX('Sheet1'!$H$1:$T$500,MATCH(1,INDEX(($B$6=' Sheet1'!$F:$F)*($C7=' Sheet1'!$G:$G),0,1),0),MATCH(D$6,' Sheet1'!$H$2:$T$2,0)) I run the indexing calculation above which looks across at other worksheets and...

Does anyone know why the following macro works fine in 2010 but is slow and eventually fails with memory error in 2016? It will open/ close approximately 7 books a second in 2010 but only maybe 1 a second in 2016. It has to open approx 8000 workbooks in total. FolderPath = "\\whatever\"...

I've currently made a user form which is used to add data into a data sheet. This was working fine up until recently when it has started taking 15 seconds to write data after the user presses save. I presume it is related to the VBA code running in an inefficient manner. The code is as follows...

Hello I am a non technical user. I am using Excel 2016 Power Query to pull data from a web API. The queries deliver 8 x JSON files and I have set the refresh rate to once per minute. The data is very basic financial market data (open,close, high, low etc) so I'm guessing the files are...