Hi,

My co-worker has a very large Excel file (over 7 MB) that suffers from the problems of (A) running slowly (B) taking forever to open/save/close and (C) freezing the computer, requiring a restart.

I set the calculations to Manual, and I repaired the file, but the file didn't change in file size and it is still having these problems.

My questions are:

(1) Is there any way around this problem or is Excel just bad at handling ~7MB files?

(2) Would upgrading RAM make a big difference?

(3) It's possible that we can't afford to spend the money on a RAM upgrade. Are there are any other ways of mitigating the problem?

Thanks.