intermittent error and lockup problem


G

Gary Keramidas

i have a client that uses a vlookup formula. the sheet it references has about
23k records.
=VLOOKUP(A5,'2007 Data.xls'!$A$2:$W$22670,23,0)

the workbook with the vlookup formula may only have 20 rows of data.

the error is "excel cannot complete the task with available resources. choose
less data or close other applications"

this works on some pc's and not others. on some it doesn't work on, it may work
when logging in as another user.

once it pops the error, it's like that workbook is locked up and task manager
has to be used to close it.

just wondering if anyone had any ideas?
 
Ad

Advertisements

N

NickHK

Gary,
Shouldn't there be some Sheetname in there also ?

=VLOOKUP(A2,[Book1.xls]Sheet2!$A$1:$O$37,3)

NickHK
 
G

Gary Keramidas

thanks, had them try it and it still messes up. don't know why on some pc's it
works and even works on some pc's when a different user logs in. tried
recreating user profiles, copying user profiles with no luck

thanks for the reply.

--


Gary


NickHK said:
Gary,
Shouldn't there be some Sheetname in there also ?

=VLOOKUP(A2,[Book1.xls]Sheet2!$A$1:$O$37,3)

NickHK

Gary Keramidas said:
i have a client that uses a vlookup formula. the sheet it references has about
23k records.
=VLOOKUP(A5,'2007 Data.xls'!$A$2:$W$22670,23,0)

the workbook with the vlookup formula may only have 20 rows of data.

the error is "excel cannot complete the task with available resources. choose
less data or close other applications"

this works on some pc's and not others. on some it doesn't work on, it may work
when logging in as another user.

once it pops the error, it's like that workbook is locked up and task manager
has to be used to close it.

just wondering if anyone had any ideas?
 
Ad

Advertisements

G

Gary Keramidas

looks like they may have tracked to down to being an active directory issue.

--


Gary


NickHK said:
Gary,
Shouldn't there be some Sheetname in there also ?

=VLOOKUP(A2,[Book1.xls]Sheet2!$A$1:$O$37,3)

NickHK

Gary Keramidas said:
i have a client that uses a vlookup formula. the sheet it references has about
23k records.
=VLOOKUP(A5,'2007 Data.xls'!$A$2:$W$22670,23,0)

the workbook with the vlookup formula may only have 20 rows of data.

the error is "excel cannot complete the task with available resources. choose
less data or close other applications"

this works on some pc's and not others. on some it doesn't work on, it may work
when logging in as another user.

once it pops the error, it's like that workbook is locked up and task manager
has to be used to close it.

just wondering if anyone had any ideas?
 

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