I am having issues with out of memory in xl2000, but i have approx 500mb ram and around 1.4gb that xl2000 can use. The easiest way i encounter this problem is when i paste a simple average(x, y, z) formula to a range of 4500x120 cells, where x, y & z are in three different sheets.
I get the usual cancel undo msges as well but do not understand why i get the out of memory in first place ?

Any ideas or solutions would be greatly appreciated as i think this may help overcome what i thought may have been a vba issue in another workbook i have.