How do I link to other data sources without resource issues?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 wold like to do this in
excel and not access if possible.
 
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
 
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!
 
Back
Top