I have a workbook that is almost 5 megs that I would like to leave closed and
have another workbook do a vlookup and find the information on that other
workbook. When I try a vlook up it tells me that there is not enough memory.
If I have the workbook just in an sheet to the main workbook then it works
fine. But if I save all of that information everytime our server will fill
up pretty quickly.

How can I have the workbook stay closed on our server and just open another
workbook and have it link to the main workbook that is 5 megs.