Excel cannot complete this task with available resources

A

AngeloSR

I need help.

I have an Excel file that is 35MB in size. This file is link to
another Excel file that is 19MB in size to get its data from. When I
tried to load the file to Excel 2003, it asked me if I want to update
the link. If I choose not to update the link, the file loads without
an error, but the data are not filled in. If I choose to update, I the
error "Excel cannot complete this task with available resources.
Choose less data or close other applications". I know Excel 2003 has
1GB of heap memory. Is it possible that all the 1GB heap are being
used? Is there any way to solve this problem. Any help is greatly
appreciated. Thank you.
 

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