slow performance

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

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

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

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

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

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

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:

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

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

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

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

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