slow

Dear all, I am helping a friend out, but I come across a problem that I am unable to solve. Consider the following file, I am unable to detect, why on earth the file opens extremely slowly and makes everything unworkable, like simply filtering and browsing the file. I have tried the following...

Has anyone experienced the excel document lagging / slowing down once the doc gets over a certain size? We write reports using excel and the last few photos we upload to it takes so long! Looking for a fix if anyone can help.

Hi all! Hopeful that you can help me speed up some of my formulas. I'm building a chain of LAMBDA functions and the most recent one is running really slowly and I can't figure out why because if I run the exact same formula just filling in the variables, it runs instantly. Details below: Runs...

I have a macro that prints several pdf's for schedules from one sheet. It takes about 10 minutes for the macro to run and make the 10 pdf's. Is there a way to make this run faster? Sub Create_Schedules() Sheet1.Activate ActiveWindow.View = xlPageBreakPreview Dim Yellow As String Yellow =...

I have this extremely strange issue with one of my VBA script JSON codes where it only runs fast (about 1 min and 20 seconds) when I open up a new workbook and insert my code and add Microsoft script reference right there. However, besides this it takes forever to run. Also if I save this file...

I have this JSON Microsoft Scripting VBA code that pulls data from a work website into Excel. Can pull about 55,000 rows of data. About 5 columns of data. On 2016 the code worked fine but on 2019, which I need the code on, it takes forever to run or crashes Excel. I then have to quit Excel. I...

I have written some VBA code which contains multiple worksheet change event triggers within a single sheet. It works as I would like it to however I find it has slowed my workbook down whenever I make any changes to it. I wondered if there is a more efficient way to write this code? See code...

I have two XLSX files, with same setup, only with different amount of rows, about 4000 line items for one, and 400 for another. ISSUE: if i enter data to any of the cells in the table, Excel will display a circular loading icon (NO CALCULATION progress) and after about 8 seconds ( does not...

Hi all, Using Excel Microsoft 365. I have an Excel Table. I deleted all data from the Table and then resized the table to $A$1:$A$2 I then added 13k rows of data beginning at Row 2. That is where the slowness began. Why does it take so long for Excel to resize the table to include all 13K...

Can someone please help me? After I upgrade Office from 2010 to Office 365, all the codes become very slow. I'm looking into the causes. I came across this really simple codes and pulled out a section. I wanted to ask all of you experts why these simple codes would take such a long time to run...

All, I created a very large Excel file (i.e. hundreds of MBs or 100,000 rows by 369 columns) for calculating a sample of about 100,000 insurance policies across five or so different companies. I started off by building out the first row with all the needed formulas and then have copied them...

Hello, I have a very long macro that's taking a REALLY long time to run (so long that my computer goes into standby mode while it runs). I narrowed the problem area of the code down to the segment below, and am wondering if anyone has any tips on how to make this more efficient. It does what...

Hi, I am beginning in power Query in Excel. I have a general issue is the speed of refresh. I have something very basic code like : Source1 = Excel.CurrentWorkbook(){[Name="tblprofit"]}[Content], #"Filtered Rows1" = Table.SelectRows(Source1, each ([Sales organisation] <> null) and...

Hi, I'm having a performance issue while running the following formula: "=Calculate(sum(lines[CB unit]),Filter(Lines,Lines[Index]<=earlier(Lines[index]))" I'm only iterating over 150K rows, but the calculation times out and never seems to finish. It works fine with 2K rows, but really starts...

Hi, I have a 2 dimension collection. The collections has 7 rows and 25 columns. Writing this collection to a sheet takes about 60 seconds, which is slow to me. The calculations are set to manual, and the displays, events and screenupdaing are set to false. What else could be causing the...

Hi! I can't seem to find a way to split cells in Excel using formulas (I need it to be dynamic, so I can't use the built-in splitter). What I have is up to 8 rows and 39 columns put into one cell. It's easy enough to get them spread out when I get them split up, but I can't split them. I can't...

Hi, This code I have to add new workbook > copy data from active sheet to Sheet1 of new workbook then save runs slow. Private Sub SaveSheet() Dim WB1 As Workbook, WB2 As Workbook Dim WS1 As Worksheet, WS2 As Worksheet NUMBERA = Sheets("Main").TextBox1.Value LR = Range("A65000").End(xlUp).Row...

Hi, I have problem with my workbook, I solved first issue with user defined functions, but now I have very slow workbook, with small amount of data (comparing other workbooks I made), can somebody help me? reference to my last thread...

Hi I realize the title is not that helpful I have a relatively large spreadsheet - around 7 MB - with a lots of calculations and 50+ tabs It calculates fine and very quickly. However, my problem is that if I move a tab or insert a blank line (even if that line does not impact any...

Hello, We have recently installed 64-bit excel for Office 365, and it seems to be very slow in response time / stickiness in cells. Anyone know what might be causing this? thanks