I have oodles of swapspace and about 500 mego ram.
office 2000
Spreadsheet is about 10 tabs three tabs devoted to pivot tables ranging from 8,000 to 24000 rows.
The spreadsheet is approximately 45 meg with another spreadsheet opened with the working data that is approximately 50 meg.
When I run the pivot table it blows up when it reaches about 140 columns across. 140~150 x 28,000 does not appear all that big for a pivot table.
I can solve the problem by removing the data which increases its columns.
How can I make the dang thing not run out of memory? the columns represent days and I need to be able to get near 200 days to make myself happy.