Vlookup Error - Looking for an answer

I Originally posted this question (read from bottom up) on 10/22/04. and was
hpoing Frank Stone or someother bright person could help me! This is driving
me nuts!
Thanks
_____________________________________________________________
I have a vlookup formula looking up a value in another file. When I Open the
file with the vlookup formula, it asks me if I want to update, yes or no,
when I say yes it will give me the message and it tries to update the values
it gives me the message: "excel cannot complete this task with available
resources.
Choose less data or close other applications."
I am using XP 2nd release
Excel 2002
System has 992MB of ram and AMD Athalon 3000

Thanks for you reply!


"Frank Stone" wrote:

> hi,
> you have given no hint or clue as to what task excel
> cannot complete.
> The "close other applications" part and the "with
> available resorces" part and the "choose less data" part
> suggest to me a memory problem.
> how much memmory do you have and what are you trying to do.
> Regards
> Frank
>
> >-----Original Message-----
> >I have a data base that I want to pull info into many
> different reports, and
> >Only want to have the one data base to update. When I do
> this it always
> >gives the error of "excel cannot complete this task with
> available resources.
> >Choose less data or close other applications." I would
> like to do this in
> >excel and not access if possible.
> >.
> >
>

"croozer" wrote:

> I Originally posted this question (read from bottom up) on 10/22/04. and was
> hpoing Frank Stone or someother bright person could help me! This is driving
> me nuts!
> Thanks
> _____________________________________________________________
> I have a vlookup formula looking up a value in another file. When I Open the
> file with the vlookup formula, it asks me if I want to update, yes or no,
> when I say yes it will give me the message and it tries to update the values
> it gives me the message: "excel cannot complete this task with available
> resources.
> Choose less data or close other applications."
> I am using XP 2nd release
> Excel 2002
> System has 992MB of ram and AMD Athalon 3000
>
> Thanks for you reply!
>
>
> "Frank Stone" wrote:
>
> > hi,
> > you have given no hint or clue as to what task excel
> > cannot complete.
> > The "close other applications" part and the "with
> > available resorces" part and the "choose less data" part
> > suggest to me a memory problem.
> > how much memmory do you have and what are you trying to do.
> > Regards
> > Frank
> >
> > >-----Original Message-----
> > >I have a data base that I want to pull info into many
> > different reports, and
> > >Only want to have the one data base to update. When I do
> > this it always
> > >gives the error of "excel cannot complete this task with
> > available resources.
> > >Choose less data or close other applications." I would
> > like to do this in
> > >excel and not access if possible.
> > >.
> > >
> > From Rossel1106;
It appears that your computer does not have enough memory to complete the
task that you are requiring your machine to do;
Try to use vlookup by using segments of the file.
>
>
>
>

The 2 spreadsheets have a combined size of probably only 30-40MB, and if it
is quite smaller, it still gives me the same error. My pc has 992 meg of
ram, I don't what that equates to in how large of a file(s) I can have opened
up or link to. Any other suggestions??

Thanks

"rossel1106" wrote:

>
>
> "croozer" wrote:
>
> > I Originally posted this question (read from bottom up) on 10/22/04. and was
> > hpoing Frank Stone or someother bright person could help me! This is driving
> > me nuts!
> > Thanks
> > _____________________________________________________________
> > I have a vlookup formula looking up a value in another file. When I Open the
> > file with the vlookup formula, it asks me if I want to update, yes or no,
> > when I say yes it will give me the message and it tries to update the values
> > it gives me the message: "excel cannot complete this task with available
> > resources.
> > Choose less data or close other applications."
> > I am using XP 2nd release
> > Excel 2002
> > System has 992MB of ram and AMD Athalon 3000
> >
> > Thanks for you reply!
> >
> >
> > "Frank Stone" wrote:
> >
> > > hi,
> > > you have given no hint or clue as to what task excel
> > > cannot complete.
> > > The "close other applications" part and the "with
> > > available resorces" part and the "choose less data" part
> > > suggest to me a memory problem.
> > > how much memmory do you have and what are you trying to do.
> > > Regards
> > > Frank
> > >
> > > >-----Original Message-----
> > > >I have a data base that I want to pull info into many
> > > different reports, and
> > > >Only want to have the one data base to update. When I do
> > > this it always
> > > >gives the error of "excel cannot complete this task with
> > > available resources.
> > > >Choose less data or close other applications." I would
> > > like to do this in
> > > >excel and not access if possible.
> > > >.
> > > >
> > > From Rossel1106;
> It appears that your computer does not have enough memory to complete the
> task that you are requiring your machine to do;
> Try to use vlookup by using segments of the file.
> >
> >
> >
> >