slow performance

  1. K

    Excel takes a lot of time to respond when i hit enter button

    I have a macro enabled excel file which is only 700 KB. Whenever i edit any cell and hit 'enter', it takes almost 45 seconds to respond. I do not have any vba program linked to any cell change event. I checked the used range for all the sheets, and none of the sheets go beyond 15 to 20 columns...
  2. KentBurel

    Need help with snail paced macro

    I've created a monster. I'm still a novice at VBA. I've been working on this project for a few weeks. I have a workbook that contains sheets that I use to build other sheets. The templates contain all the data I need in the final sheets. So I just copy the sheet to a new sheet, rename it...
  3. R

    Power Query takes ages to load JSON data from web

    Hey everyone, I'm pretty new to Power Query and am having some trouble when it comes to loading times. When I refresh all data in the workbook (which is just the queries) it takes 7 minutes (I got a little frustrated and actually timed it haha) for everything to load and for me to be able to...
  4. L

    Not sure why my simple copy rows is running so slowly

    Hello, Maybe someone here will be kind enough to help me. I have a simple subroutine but it runs incredibly slowly. I have one sheet CodeName "SellHack". For now there are about 700 Rows. About half of the records have "verified" listed on Column "O". I'm trying to copy all of the rows...
  5. jgrob3

    Can't Delete Query "Being referenced by other queries"

    I have a client that has 24 months' of data (52 queries) loaded into PowerQuery, with 200K-700K of records in each query. They've been appending each query to the previous data to create a single large table of data that can then be used by PowerPivot for reporting. From time-to-time, the data...
  6. G

    Extremely slow spreadsheet with certain Windows Regional Settings

    Reporting very unusual problem with an Excel spreadsheet. The spreadsheet loading time & flicking through values within the drop down menus varies considerably depending on the Windows Regional Settings. I need to solve this ‘performance problem’ asap, but cannot find any logical explanation or...
  7. M

    Slow to complete minor changes

    Hello, I work in xls 30hrs> week now & cannot figure the following. I work relatively large (~10K-20K lines X ~40 Columns). My Problem: about half the time, my worksheet will take >2mins to do something as simple as deleting a column or applying a new text color. What can I do? MK :confused:
  8. S

    Like expression cause performance problem

    Here is part of the codes. I want to use the statements to check if the email subject matches to any of the subjects saved in column K. It can execute without problem. However, email subject can vary from time to time, but still it should contains some key words unchanged. So I tried to use Like...
  9. T

    Something about this code is making Excel Freeze

    Hey all! I think it might have something to do with the subsequent calculating, but this code seems to be the culprit when it comes to making my Excel seemingly freeze: Dim rng As Range With ActiveSheet.Range("E12:E600") Set rng = .Find(What:="Total", LookAt:=xlWhole, LookIn:=xlValues)...
  10. G

    Excel formatting takes too long virus/corrupt files???

    Hi I have an excel form/file which I open from an Excel Macro. The excel macro does some formatting etc to the form/file while it is being opened. Everything has been running fine for over a year. However now for some unknown reason, there is some huge waiting time on some cells when I try to...
  11. N

    View Matrix Data in a PivotTable?

    Hi all, any help with this would be hugely appreciated :) I have a marco which does what I want, but it’s so slow that I think there must be a cleaver more efficient way to do the same thing. I’m hoping all you smart guys and gals will have some ideas!! What I have is a resource allocation...
  12. T

    Seeking Help - My spread sheet is SLOW!!!

    I am attempting to do more with Excel 2007 than it was probably meant to do. I have LARGE SUMPRODUCT command refferences and now my spreadsheet is very very slow. My sheet includes many tabs that all refference back and forth to each other as well as a single entry with approx 500 dependents...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top