cpu usage

I am having an issue that is hard to reproduce with a workbook I created. Essentially it is an order entry system that is done through the use of userforms. Users can enter orders, and retrieve existing order entries and edit them. Now sometimes, and I can't say for certain if it's when the...

I am building a high spec computer as below. 64GB 3200MHz DDR4 RAM 11GB GTX 1080 Ti GPU 1TB SSD PRO SM 961 M.2 Hard Drive I am in a dilemma which CPU to install My worksheets consist of up to 800,000 rows and around 75 columns, most containing formulas. size around 500-800MB. No VBA is used only...

2010 Excel Running on HP Thin Client server I have a 12mb file with 308,000 rows of txt and a mere 6 columns. I have one column vlookup formula. As txt I can filter like normal. After adding a Vlookup column and a summary sheet containing 6 cells with a sumif. In my mind, not a terrible...

Is there anyway to get this version of excel to use more memory? I have 8GB available but it seems to only use 1 GB for processing.

I have one Sub that seems to keep bumping my CPU Usage to 100% and basically freezes everything up. I can't see anything unusual about the code but without uploading all the code, is there something I could do to alleviate this situation. My process works only with 2 files. One looks up data...

I have a macro that runs for approximately 90 Sales Rep files. The macro itself runs fairly quick but I have noticed that I am unable to do anything while the macro is running due to Excel Automatic Calculate will use 100% of the CPU Usage throughout the macro. I have to calculate the...