2009
09.04
09.04
Quaim asked:
I am working on a huge 35-40 MB Excel file with thousands of records and complex formulas. The system computes and subsequently hangs after every small operation. How can I get away with this? My machine is new and it is Centrino, 80GB. I have disabled the ‘Automatic Calculation’ option in the Tools menue to avoid frequent computations but it does not help much.
Hector
I am working on a huge 35-40 MB Excel file with thousands of records and complex formulas. The system computes and subsequently hangs after every small operation. How can I get away with this? My machine is new and it is Centrino, 80GB. I have disabled the ‘Automatic Calculation’ option in the Tools menue to avoid frequent computations but it does not help much.
Hector

Annie
I think you need a machine a bit more powerful than a centrino.
Sounds like you need an IBM system 36 that can handle multiple functions with large files.
Turn off all non essential programs- screen savers, etc. How much ram do you have ?
Hard drive is ok, but how much processing power do you have?
Good luck.
Denise
Is it definitely hanging - I mean is the whole system locked?
How much RAM do you have and how big is the virtual RAM?
I guess the 80GB refers to disk space. What processor speed?