cpu

  1. C

    BAD CODE HIGH CPU USAGE? VBA

    Hello! I'm stuck with this for several weeks and that's why I'm asking for your help. This code interacts with a third party application, sending values and printing documents from it. It works fantastic, only for the small detail that with the passing of the iterations the cpu fan starts to...
  2. S

    Excel to Check System settings/requirements

    I have a program that is on a USB drive (iso mounted on usb as .exe from an original CD- no license key needed). I'd like to have a series of macros that do the following but I have no idea how to get Excel to do much outside of the program itself. Macro1: checks system "requirements"-...
  3. M

    Very slow pivot on similar PCs (performance issue)

    Hi, I'm new here. This is the situation: In my office I have 2 pc with very similar configuration. 16 GB ram and similar CPU (I7 4790 vs I7 6700). When I try to update, or simply put or remove a filter on a column the performance is very different. For example, If I insert a filter on a column...
  4. B

    Compare Two Pairs of Cells and Mark Rows with Matches

    Hey Guys - I have two worksheets which each have about 6 columns. Examples below... Worksheet #1 Example (Original) A B C D E F G PCModel1 PCManufacturer1 Value Storage CPU Link1 Link2 PCModel2 PCManufacturer1...
  5. C

    Running Java jar file from excel

    Hi, I have an excel column in which I have created java command (using formulas etc based on other columns). There are more than one cells in the columns with respective Java command. I want to run them in loop so that when Java command execute it will create some files for me. I just want to...
  6. R

    Are more CPU cores better for huge Excel data sets ?

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

    New cpu. Xeon vs i7. What’s better

    Hi I’m looking at purchasing a new pc. Willing to pay $2500. What’s better a Xeon cpu or i7. Will put in ssd drive and 32gb ddr4. Looking at Dell xps or dell precision. Thoughts?
  8. S

    Need to buy a high end EXCEL pc.

    Hi I need to purchase a new high end PC. I currently have a 2 year old XEON pc, with 32gb ram, 64bit, SSD. I need more power from Excel. Cant figure out if i need more ram or a faster processor with more cores. I use a 100mb file that OBDC to our server. But I only see about 20% cpu usage and...
  9. S

    buying a powerful pc

    Hi. I’m looking to replace our computer at the office. It is currently a Xeon processor with 32 gigs of RAM. We connect to a sql server that is located on site and the current Excel file size is 100 MB. I’m looking to get a very powerful system as we live inside excel numbercrunching. What would...
  10. H

    [HELP] How to extract specific text from from .txt file to excel vba

    Hi Sir, Question if I want to get the information on the text file please see red color that is the information I need to get what will be the code I will use button also I just want All .txt files in the "C:\Users\Andrew Sangalang\Downloads\Logs" folder are to be processed I have many text...
  11. 1

    Hardware priority for Excel?

    Hello, excellers =] This is my first post, and happy to join the vibrant community! I recently build a 775 socket desktop with modified 771 xeon e5450 cpu. With 16g ddr3 ram and ssd, it cost me about $200, including a $50 motherboard from the age. Before this, I used an ivy-bridge i5 desktop...
  12. T

    Excel using RAM

    Hi, I have Excel running on windows 7 64 bit with 4 GB RAM. I need to work with large files and perform many calculations on a few hundreds of lines. At the moment it runs pretty slow. What should I invest when considering a new computer for that matter: a very strong CPU or plenty of RAM. In...

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
Back
Top