Is there a maximum # of calcs you can run in a spreadsheet?

[melodramatic]

I am trying to copy a calculation down 10,000 rows for 12 columns - but every time I try, it bombs out at about Row 4000, and won't let me go any further. If I try to manually put in any other calculation on the spreadsheet at the time, it won't save.

Is there a maximum number of calculations you can run on a single spreadsheet?

I've got several sheets
Sheet1 - 30000 calculated cells
Sheet2 - 30000 calculated cells
Sheet3 - 40000 calculated cells
Sheet4 - 110000 calculated cells
Sheet5 - 180000 calculated cells (this is sheet where I'm having problems)
Sheet6 - 1000 calculated cells
Sheets 7, 8 & 9 are all charts

I know that I've run these number of calculations before. This is driving me nuts!

Any help you can give would be much appreciated.

 

[Andrew Poulsom]

There are memory limits:

http://www.decisionmodels.com/memlimitsc.htm