performance

My file's not large in absolute terms (2MB), but has a dozen worksheets, several thousand formulas, a bunch of VBA macros I run, and on top of that is pulling in real-time tick-by-tick stock market data via DDE. This results in a lot of lag, and occasional crashes. (In the lower-right of the...

I'm tying to rebuild our sales rep quarterly/year-end performance report to account for quarterly metrics weighting changes. Generally the performance metrics (attainment to quota and product volumes) have the same weightings each quarter so calculating the year-end ranks are easy, (YTD...

I know this is an Excel forum but I don't where else to turn. My computer is running rather slow, does anyone know of any free software that is virus free that will help speed up my computer performance. My excel files are taking forever to load and I don't have any programs open other than one...

Hello, I am currently working out a dashboard in Excel 2016, which might be used on earlier versions of Excel as well. Right now, the speed of the dashboard is alright, but I would like to know of any enhancements in performance if possible, as there might be added more data later on, or it...

Hi everyone I have an excel spreadsheet that is linked to a SharePoint list. When I open the excel file, the source data goes to the SharePoint list and updates the data. I then use this data and built 8 pivot tables for various purposes. Due to the filtering and grouping requirements, I...

Hello, I am going into the consulting business and will be buying a laptop for the business as the work is at the client site. I will be using Excel, Word, PowerPoint, Access, Viso, and other stuff. But Excel is the money maker as it drives the analysis and the program I care the most for to...

Hello, I am trying to preform a duplicate row check on a data set spanning over 6 columns and approx. 250,000 rows of data. What I am trying to find is the more efficient way to highlight any duplicate rows. The code I have at the moment currently take around 45 minutes plus and I can’t help...

As a follow-on to this thread: https://www.mrexcel.com/forum/excel-questions/997745-im-going-crazy-trying-get-cell-offset-working.html Now that I've got my VBA code working, I'm wondering if there is a way to speed it up. My code reads data from a small (12KB) log file, parses it into VBA...

Hi Folks, I have created a macro splitting a block of data into many excels. It works for active sheet and as a criteria it uses a selected cell. Macro itself works fine, however I am encountering some problems with performance and object methods. The error occurs every time I reach ~105...

I want to track performance of my service techs. I want to measure them monthly by service request turnover and average age of service requests. Turnover is how many new requests were generated during the month and how many were closed. Target is 100% Average age of service requests is how many...

Hello, I have been reading this forum for a long time and so many times was able to find solutions to the challenges I was facing so thank you all for all your contributions! However finally came to the the point where I had to register to write the first post as I am struggling with one of...

<tbody> I wrote a macro that compares the columns B, which contains file numbers, in two worksheets. There are three possibilities: the file number exists in both columns, the file number exists only in the first column and the file number exists only in the second column. If e.g. the file...

My company just "upgraded" to office 2013 and now one of my macros that ran perfectly in 2010 now seems to have a handful of issues. 1.It runs at a fraction of the speed ,2010- ~15 seconds per account vs 2013 ~ 1 minute per account.I have already tried disabling Animate controls and elements...

My code need more than one hours to complete for 3500 rows data but I need to work for more than 40000 rows data. I am looking for alternatives to my code by using dictionary, with improved performance within the context of interest. Could anyone help me? <code style="margin: 0px; padding...

Having trouble with speed of a vba script for importing data into an excel table. Hoping someone here can help. As the comments in my code state this script takes about 8 seconds to import 100 rows of data. I would love to bring it down to fractions of a second. Sub ImportMyData()...

Hello, I have the bit of code below that work fine but it is very very slow. This is due to there being two loops within the main code and a Levenshtein function also imbedded. I was just wondering if anyone can help advise on possibly speeding it up. The code basically does a Fuzzy lookup to...

Hi, I have a database with worksheets for multiple companies and am trying to consolidate them into one masterlist, as well as run a couple other reports. I believe I have the reports working as intended but am experiencing very long processing times in running the masterlist generator. Does...

Hi there! If you have a field which contains only VARCHAR below 30 characters: Would it then make sense to set Field size to 30? (to get better performance). ...or is it better to leave the default field size settings?

Many formulas return an array result when given an array. For example, =ROW(range) returns an array of row numbers. And this formula returns an array of cell addresses in a range: =ADDRESS(ROW(range),COLUMN(range)) But when entered as a single cell formula, you may not realize you're getting...

Hi Everyone, I'm using Excel 2007 on Windows 7 I'm not sure how to best describe this with the appropriate terminology. I appreciate the patience of you experts. I have a range of monthly performance for a benchmark and my portfolio. I am looking to identify periods where I can set the...