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?