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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top