Upgrade or Not Question....

[mikesal57]

For excel or access.....

I have an Ryzen 5 3600....

Will a Ryzen 9 5900x help in speeding up these applications?

I do have an Excel Sheet with over 250,000 lines and 3 tables of info...it takes me well over 2 mins to open...

I have the same in Access but that opens in a wink...

Should I upgrade?

thxs guys

 

[DRSteele]

I know diddly about hardware, but when it comes to software I can tell you that you would benefit greatly by updating to Excel 365. It has a new calculation engine that is orders-of-magnitude more efficient. It is much faster, it has several new functions that are immensely powerful, and it uses dynamic array technology.

 

[mikesal57]

Thxs for an option but I prefer Office on my PC .....

 

[Fluff]

365 is on your PC just like any other version.

 

[DRSteele]

Office 365 is on your PC. It is also online.

 

[mikesal57]

Thxs guys....

It really didn't answer my question but I'll check it out

 

[Fluff]

With over250,000 rows of data, you be be better off using a database. I doubt that using a different computer will make a lot of difference.

 

[mikesal57]

Ok..got it....you opened a can of worms now when I send you my question

 

[Joe4]

I do have an Excel Sheet with over 250,000 lines and 3 tables of info...it takes me well over 2 mins to open...

I have the same in Access but that opens in a wink...

Yep, that tells you right there which is the better tool for the project!

General rule of thumb: Relational Database Models work better in relational database programs, like Microsoft Access or SQL.
Though you can brute force Excel and try to use it as a relational database, it is not what it is designed to do, and performance can really take a hit as your data grows.

Note that the "Power Query" tool in Excel makes it easier to do database-type operations in Excel.
I haven't really used it much myself (as I use Access for databases), but there is a forum for it here (Power Tools).