Processors
Intel® Processors, Tools, and Utilities
15994 Discussions

Best processor for EXCEL

Bill777
Beginner
5,189 Views

I do EXCEL files that make much use of very small cells and formatting and conditional formatting.  Also, I have files that include many cells containing repetitive and often long formulas.  Today for instance, I am working in a file that if displayed on my screen to suit, I would be viewing 2300 rows and 2600 columns.  However, when I zoom out to view this large array, my EXCEL slows to a horrible slow pace.  The only way I can have any functionality at all is to zoom in much closer than I prefer, simply to have fewer rows and columns in view.

I just bought a machine with an i9-12900H and a decent Nvidia graphics card.  Also, I expanded the RAM to 64GB, simply in desperation to improve performance.  I am still having the same problems.  I have heard from experts that EXCEL is a bit obsolete, so maybe I cannot expect any better.  Still, I hope that I can somehow do better.  SO, my question is this.

WHICH ONE OR MORE INTEL PROCESSORS SHOULD I PURSUE IN ORDER TO GET THE BEST PERFORMANCE IN EXCEL?

Thanks!

 

0 Kudos
6 Replies
AlHill
Super User
5,181 Views

The processor is not your problem, nor is this forum appropriate for your problem.

Contact microsoft regarding excel issues, and verify that you meet the requirements of this so-called obsolete software.

 

Also, do not forget to release the CAPS LOCK.

 

Doc (not an Intel employee or contractor)
[Maybe Windows 12 will be better]

0 Kudos
Bill777
Beginner
5,160 Views

Wasn't expecting the word "appropriate" to appear in any response.  Thanks for your jaundiced response.

0 Kudos
AlHill
Super User
5,156 Views

What did you want to hear?  You are handling a massive array in Excel, for which version you did not specify, nor did you specify the OS.  You say "experts" told you that Excel is obsolete.  Tell that to Microsoft, or tell me what these "experts" recommend as current spreadsheet  software that could handle your needs.

 

You say you have an "decent" nvidia card, which you did not specify.  "decent" is a relative term.

 

But, if you have a decent nvida card, 64GB ram, an i9-12900H processor, with Windows 10 or Windows 11, a current version of Excel, and SSD storage for your OS, apps, and data, and you are not getting the performance you want from this "obsolete" software, then what would you have us do?

 

My feedback is not juandiced, but realistic.  I am thinking the problem is a poor implementation of your needs in software that is not suited for your array of 6 million cells.   So, instead of facing reality, you go straight for the processor.  Yes, that must be the problem.  Not your implementation or your design.

 

I recommended you contact the Microsoft support Excel forum for their help with their "obsolete" software, and what hardware requirements are needed.  Instead you come back here to moan about my response.

 

Wait, maybe my response is jaundiced....

 

Doc (not an Intel employee or contractor)
[Maybe Windows 12 will be better]

 

0 Kudos
Bill777
Beginner
5,143 Views

It is clear from my post that I am someone who needs help.  I came to this forum to seek help.  Thank you for your time.  No further assistance from you is sought at this time.

0 Kudos
AlHill
Super User
5,142 Views

No problem.   You should consult with Microsoft for design considerations regarding their software.  Throwing hardware at the problem will not correct the problem.  You need a proper design, and then select hardware appropriately.

 

Good luck.

 

Doc (not an Intel employee or contractor)
[Maybe Windows 12 will be better]

0 Kudos
Bill777
Beginner
5,130 Views
0 Kudos
Reply