Excel cannot complete this task with available resources. Choose l

M

milos

Hi,

In one Excel 2007 file when try to paste about 80 formulas from one sheet
to another I recived message "Excel cannot complete this task with available
resources. Choose less data or close other applications" Memory go to 2,4 GB
in use and PC go very slow. Try on other PC and same problem.

Formulas are SUMIF()

File is about 10 MB and have 50 sheet's.
 

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