excel 2007 resources

[Person]

Is there a way to explicitly allocate more memory to an Excel 2007
process? I'm trying to run an array formula on a huge (300k rows)
dataset and I'm getting "Excel ran out of resources while attempting
to calculate one or more formulas. As a result, these formulas
cannot be calculated."

I thought the whole point was to overcome such limitations? Is
there anything I can do?

I can provide more details about the application (many thanks to H.
Grove in m.p.e.w.functions) - perhaps my question is too general.

Thanks for any advice/input...

 

[T. Valko]

I don't have Excel 2007!

To improve the performance of Excel, memory management has been increased
from 1 GB of memory in Microsoft Office Excel 2003 to 2 GB in Office Excel
2007.

The number of array formulas in a worksheet that can refer to another
(given) worksheet
Old Limit: 65k
New Limit: Limited by available memory

Biff

 

[Bob Phillips]

I would guess it is all down to available resources, you may be using what
you have. How much memory do you have? I have only installed 2007 on 2Gb
machines.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Person]

I would guess it is all down to available resources, you may be using what
you have. How much memory do you have? I have only installed 2007 on 2Gb
machines.

1.5Gb - woulda thought that was plenty...how many copies of 35 Mb's
worth of data would it need to make in memory? Seems very odd...