PDA

View Full Version : Adding Extra Memory - Will it help Excel



peacenik
09-17-2008, 12:07 AM
I am doing a lot of work with VLOOKUPs across multiple large (50K record) sheets and am regularly getting crashes, to say nothing of taking ages to calculate.

Does anyone know if I would get much benefit from buying some extra memory. I currently have 2GB.

MaximS
09-17-2008, 01:15 AM
Redesigning will be better option than buying memory card.

You can always try your file on more powerful machine to see if there is any difference.

Bob Phillips
09-17-2008, 01:26 AM
There is not much more that you can add (if you think 2Gb isn't much :-)), 32bit machines can't fully address 4Gb. Also, your problems seem dire, so more memory doesn't sound like a practical long term solution. I would agree with MaximS, redesign, redrafting is the way forward.