Excel cannot complete this task with the available resources. ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having problems with a data set in Excel. When filling rows with a
formula with the fill command I get the following error:

Excel cannot complete this task with the available resources. Choose less
data or close other applications. Continue wihtout Undo?

When pressing OK, a second message is:

Excel cannot complete this taks with available resources. Choose less data
or close other applications.

Then, only stopping Excel in task manager helps.

The formula I am filling down is simply adding 4 values from two different
sheets of the same workbook. The data set contains 64000 rows.

I am using a P4, 3Ghz, 1GB RAM, 80GB drive

Thanks for any help.

hms
 
Back
Top