Alternative program to Excel for array formulas

  • Thread starter Thread starter Minister
  • Start date Start date
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?
 
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

Back
Top