parts justified for 2700x

[varunsonu]

Hi Guys,
I have just built my first PC and the performance is amazing but it does not solve my real purpose of getting this built. I work with huge excel files with million rows that use vlookup and sumifs and hybrid of count and if functions. The reason for getting this PC was to get the work done faster but i am not getting much difference coming from a dual core I5 and 4 gb ram. My new build has:

Ryzen 2700x
B450M Mortar
8 GB 2666 MHZ g.skill ripjaw Vseries
240gb WD green M.2 SSD
Nvedia 710 2GB graphics card
Gigabyte 500W bronze certified PSU

I have overclocked the processor to 4.15 mhz however the ram cannot be overclocked. I notice a HUGE difference in performance from my previous laptop but i don't notice much difference in the excel calculation speeds which is the real reason this PC was built. Although I don't plan on using this PC for anything other than a workstation but i want the 2700x to run at its full efficiency after spending all that money. 
Can anyone see a bottleneck anywhere which is most likely to slow down excel calculations or the PC in general. I can still exchange the parts. I don't plan on playing games or video editing so don't require a graphics card. Any recommendations will be helpful. Thanks
Varun

[TH3R34P3R]

maybe, just maybe pick up more ram? i'm not certain that will solve the problem, but it should help for the CPU. and ryzen likes fast ram, 3000mhz if possible. 

 

but is excel on the SSD or a hard drive?

[TH3R34P3R]

18 minutes ago, varunsonu said:

8 GB 2666 MHZ g.skill ripjaw Vseries

is this one stick or 2 sticks that are 4gb each? because that can be slowing you down dramatically. 

[DailyProcrastinator]

When you are working in excel how much RAM are you using? If the files are really big you are running into RAM limitations most likely and that is why it feels slow. When RAM is fully used it start using your hard drive and that creates a huge bottleneck. 

 

When I work in excel everything is lightning quick and I have an R7 1700 and 2x16GB of RAM. You probably need 16GB.

 

26 minutes ago, TH3R34P3R said:

is this one stick or 2 sticks that are 4gb each? because that can be slowing you down dramatically. 

Not being dual channel wouldn't make THAT much of a difference at all. OP is describing it as being as slow as his previous system with a dual core I5 and 4GB of RAM when using excel.

[varunsonu]

I only have 1 SSD 240 gb WD green m.2 so excel is on SSD and its 1x8gb 2666 mhz ram. I was thinking of getting the 8gbx2 trident z but it costs 210 USD in my country and i don't know if the speed boost will be enough value for money

[varunsonu]

23 minutes ago, JM21 said:

When you are working in excel how much RAM are you using? If the files are really big you are running into RAM limitations most likely and that is why it feels slow. When RAM is fully used it start using your hard drive and that creates a huge bottleneck. 

 

When I work in excel everything is lightning quick and I have an R7 1700 and 2x16GB of RAM. You probably need 16GB.

 

Not being dual channel wouldn't make THAT much of a difference at all. OP is describing it as being as slow as his previous system with a dual core I5 and 4GB of RAM when using excel.

I am generally using 50% of my ram at any point. On rare occasions it jumps to 80%. I read somewhere that excel can only utilize 2gb of ram. It has limit of 2gb for some reason. My files dont go over 50mb. If the ram only seems to be the bottleneck then i will go for the upgrade. would the speed matter too much between 2666 mhz and 3200mhz?