Excel cannot complete this task....


G

Guest

Hi all

I have a Vlookup formula that looks into a separate workbook (called
Deadlines) and scans about 3000 rows and 25 columns for information.

Today I added 3000 odd rows to the Deadlines workbook and now I'm getting an
error message of: "Excel cannot complete this task with available resources.
Choose less data or close other applications."

No other applications are open and I can't choose less data.

I'm using Windows XP with office 2000 applications.

Does anyone know of any solutions to my problem????

Would splitting the data into two separate workbooks make any difference? I
can split the data into "types" and use a formula like this:

=if(A4="Type 1",vlookup(A3,deadlines1,23,0),if(A4="Type
2",vlookup(A3,deadlines2,23,0),vlookup(A3,deadlines3,23,0))

I'm asking before I try it in the hope that someone can advise me -
otherwise I'll waste alot of time moving data, redefining areas and changing
formulas for no result.
 
Ad

Advertisements


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