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

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
 

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

Top