Crashing due to large file

[MB]

I am working with Excel and have, I think, too much data
for it to deal with. I am dealing with data in a
13,000x30 grid. On a second worksheet, I want to divide
each of those values by the average of each column from
the first, ie end up with a number in a new 13,000x30
grid. On a third worksheet, I want to divide by the
stdev. I can get the second worksheet to function, but
when I try to paste onto the third sheet, Excel hangs.
In task manager it says "not responding". I then turned
off automatic calculations and was able to paste the
information into the third sheet. However, it crashed
when I tried to save. The file is 17 Mb when the first 2
sheets are filled out and Task Manager says Excel is
using 77 Mb ram. My computer has 1.5 Gb ram. How can I
get this to work?

I am running Windows and Office XP Professional.

 

[Nick Hodge]

This isn't going to help much but something's have to be trimmed down and
taken in 'bite-sized' chucks in Excel because the processing power and
resources just can't cope. Excel can only use a 'pool' of memory so more
than that doesn't help much.

People may have heard this from a man before, but 'size isn't really
important' I have 50mb+ excel files that behave perfectly, but little
processing work goes on in these. Do several VLOOKUPS down Excel's capable
65536 rows and you should go off on holiday while it thinks about it.

You might consider if you can do this in a pivot table? You might consider
using different, faster functions to get at what you want, or, you may think
about taking in less data (Say if you are taking a month, take a week or a
day) and process several times.

As I say, not much help but just a few ideas

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)