slow excel

I've been following these forums for quite some time and finally have something to ask all the experts here. I am working on learning to code in VBA, and I've been using code that I've found around the web to build up on what I need for my worksheet. My objective is to hide rows and columns on...

Hello guys, I have a problem with my excel file, this is very small 174 KB and not particularly complex in formulas, just a few arrays and simple vlookups or math formulas, but it's sitting on dropbox. It takes a very long time for taking actions as well as saving. I have deleted all the not...

Hi, running excel 2013 on a 64bit machine. I have a workbook which, via the use of a few vba modules, scrapes web pages, pastes them into a worksheet and then parses the data which is then saved as single sheet csv files. The code below is how I get the data into excel. I suspect it is not the...

All, I have a somewhat sophisticated excel, with many macros and a lot of conditional formatting (hereafter "CF"). I know that CF is making my worksheet slower. However - there is something else as well. Every time I use one of my macros (even ones that do not do anything important) the...

I have an Excel file (I don't consider it to be too big (88,000 KB) that also references one other data dump file so sometimes caches an extra 42,000 KB. When end-users are using the file and actually in the file, everything runs very quickly; however, I am starting to get complaints on how...

Hi all, I am looking for someone with some spare time ("What's that?" I hear you ask) to have a detailed look over a personal project I have been working on. I have created an Excel 2010 workbook designed to monitor market prices of items in an online game I play, as well as keep records of my...

Hi everyone I have had a table array formula set up for many years in my main spreadsheet. I also always have my xls set up with "automatic except tables", so the tables only calculate when I want them to, or when I save. A few weeks ago I added several (60-ish) columns to a different tab...

Hello all, I have this code in place: Range("G18:M28").Interior.Color = xlNone Range("G18:M28").Font.Bold = False Set S = Application.Intersect(Range(Target.Address), Range("G18:M28")) If Not S Is Nothing Then Range("G" & Target.Row & ":M" &...

Hi, I am building a interactive spreadsheet where the user can select from 5 filters (e.g. department, team, name, etc) on certain items which will then update the table being viewed. I'm unable to use Pivot tables as it has to work between 2003/2007. I've got it working using Sumproduct but...