Help with slow loading and recalculation of work books.

[john.bedford3]

I have created workbooks to analysis data for my fishing. There are 12
workbooks (each containing 48 sheets), one workbook per year for the last 12
years, each approx. 12,600KB. Each years workbook is linked to the following
years workbook by some 1000+ cells.

The data is fed into these workbooks from 2 associated workbooks, one of
approx. 10,700KB and another of approx. 2,150KB.

All the workbooks contain numerous volatile calculations using TODAY() and
many of the sheets within the 12 yearly workbooks contain INDEX/MATCH lists
of data either from within the workbook of from the 2 associated workbooks.

I an running windows 98 second edition and Excel 97 on a computer with a
Pentium II processor. The hard drive is 6137MB(FAT32) of which just over
half is available space. I have 192MB RAM.

I have looked through http://www.mvps.org/dmcritchie/excel/slowresp.htm and
have done what I can to solve slow response of loading and calculation. To
load each of the yearly workbooks together with recalculating links takes
between 1-2 minutes and I can only load 2 workbooks (attempting to load a
3rd results in an out of memory message). It would be an advantage if I
could load up to 3 workbooks at a time but, this is not essential. However I
would like to be able to speed up the loading and calculation. Would an
increase in memory help with this and if so, how much improvement in loading
and calculation time could I expect to achieve?

Any help would be gratefully received.

 

[aaron.kempf]

you're crazy use Access for this much data

Excel is passe and it has been for 10 years already

 

[Bill Sharpe]

Much as it pains me, I tend to agree with Aaron. A database is called
for here, although you might try upgrading to Excel 2003.

Bill

I have created workbooks to analysis data for my fishing. There are 12
workbooks (each containing 48 sheets), one workbook per year for the
last 12
years, each approx. 12,600KB. Each years workbook is linked to the
following
years workbook by some 1000+ cells.

The data is fed into these workbooks from 2 associated workbooks, one of
approx. 10,700KB and another of approx. 2,150KB.

All the workbooks contain numerous volatile calculations using TODAY()
and
many of the sheets within the 12 yearly workbooks contain INDEX/MATCH
lists
of data either from within the workbook of from the 2 associated
workbooks.

I an running windows 98 second edition and Excel 97 on a computer with a
Pentium II processor. The hard drive is 6137MB(FAT32) of which just over
half is available space. I have 192MB RAM.

I have looked through http://www.mvps.org/dmcritchie/excel/slowresp.htm
and
have done what I can to solve slow response of loading and calculation.
To
load each of the yearly workbooks together with recalculating links
takes
between 1-2 minutes and I can only load 2 workbooks (attempting to load
a
3rd results in an out of memory message). It would be an advantage if I
could load up to 3 workbooks at a time but, this is not essential.
However I
would like to be able to speed up the loading and calculation. Would an
increase in memory help with this and if so, how much improvement in
loading
and calculation time could I expect to achieve?

Any help would be gratefully received.

 

[john.bedford3]

I would if I had Access.