Excel using RAM

[tanababa]

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 other words, what would excel use more efficiently? Would an increase of RAM from 4->8->16 help significantly?
Thank you,
Tamir

 

[Aladin Akyurek]

Both strong CPU and lots of RAM would help. You should also re-consider the formulas you have for efficiency (see decisionmodels.com).

 

[tanababa]

Both strong CPU and lots of RAM would help. You should also re-consider the formulas you have for efficiency (see decisionmodels.com).

Thank you,
However, I was hoping for a more specific answer.
Like how does increase in memory affects Excel's calculation...
Tamir

 

[mole999]

Aladin was showing you where to look Excel Memory Limits - Decision Models which gives the answers you need to make your decision

 

[tanababa]

Great Thank you.