Large Data base

[Croozer]

I have a database that is made up of product codes, part numbers, cos
and prices. This database is 10 columns wide by 60,000 rows. Thi
file is used by 3 or 4 other workbooks. One being a quote form, on
being a purchase order, one being a order sheet.

I would like to be able to update the database in 1 excel file and lin
to the other 3 or 4 other excel files. I currently use this format bu
have my database in each of the other4 excel files. So when th
database is updated (from corporate) I have to copy this database int
the 4 other excel files.

My question to all of you is there a way to do this having to updat
only one database and not have to update the database in the other
excel spreadsheets? When I try to do this I cannot save the in dat
that I have vlookup formulas in them as it says that I don't hav
enough memory to save it choose less data.

I use to the vlookup formula in the excel form to extract th
description cost and price by in-putting the part number, and it fill
the other info in.

This problem has plaqued me for months, Am i using to big of a dat
base, any work arounds?

Thanks for your help

 

[Frank Kabel]

Hi
you could of course use a cell reference such as
='c:\temp\[data.xls]sheet1!'A1
and copy this for all data cells

BUT having 60000 lines this will probably be too slow.
Another option would be to share the workbook 'Tools - share workbooks'
BUT this is IMHO not a very stable feature.

My suggestion would be considering the amount of data you have and the
requirement for multiple accesses to not use Excel for this but a real
database (e.g. MS Access)