At work we analyze salesdate of several departments for
years 2002, 2003 and 2004. In total I have a worksheet of
30 MB (!), 10 worksheets (some of which have 20.000 lines).

From the worksheets we get the date using vlookup and
sum.if functions to get a summary report with comboboxes,
allowing the user to select summary of days or months.

Due to enormous amount of functions to calculate, the
worksheet isn´t practical anymore; it takes ages ( 10
seconds) for each query of the combobox to be executed. On
my P-III 600Mhz (with 256 Mhz internal memory) with
Windows and Office XP I can´t even get workbooks opened
anymore!

I am looking for a solution:

1. Get a more powerful computer
(Disadvantage: my collegeaus with P-IV 2,4 Ghz and 256 Mhz
have same problems - so this solution does not seem
adecuate)

2. Get data into a real database.
(Disadvantage: the formula´s used can´t be exported easily)

Does anybody have suggestions as how to get our workbooks
manageable?

TIA

Martin