Alternative program to Excel for array formulas

M

Minister

We're using a quite powerful machine: quad core extreme CPU, 4gb of Ram, XP
Pro.

However, we're dealing with array formulas which refer to a worsheet of
205,000 rows * 23 columns (ever-increasing).

Excel doesn't operate properly and on manual calculation, it shows the
message:
"Excel ran out of resources".

Is there another way to calculate such large an amount of information?
Another program that is?
 
J

Joel

Access is better designed to handle large databases. You can put the data
into Access and still use Excel as a front end to access the database using
VBA code or queries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top