Discussion Locked

External Links In Excel 2000

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am currently trying to link two seperate file in Excel. The main file is a stock file on the main server with costings etc roughly 6Mb in size. The other is to be used on individual desktops to access the stock file. Using the VLOOKUP funcion, data can only be read if the stock file is opened ib Excel as same time as the quering workbook. Is it possible to have the sort of functionality I am looking for or could you advise a suitable alternative. I have thought about creating a VB solution but dont have the time to do same.

Many thanks in advance,

Eoin.

5 replies

by timp999

Multiple clients sharing an Excel workbook as an external data source is very inefficient.

Much better would be to create the Server file using MS Access or a similar database engine. You'll get better data, with less errors, and much less storage space will be required. You can easily attach the database as an ODBC source in Excel, and have the same functionality as you now have.

I don't know your expertise or your application here, but you could also take it a step further and create a web-based client system rather than having the clients use Excel. This type of system is handy for applications like call centers where pricing, availability, and order entry are the primary functions.

I can correspond with you in more detail about the conceptual aspects if you like. Whichever way you go, good luck!

Tim

by sankulpune

Hello Eoin,

Why not try this:

1) Create a new worksheet in your wxisting workbook.
2) CopyLink (edit > copy and then edit > paste special > copy link while both files are open) the data from the Server file in this worksheet.
This way, data will be updated even if the server file is not open.
3) Use look-up in this local sheet.

I have successfully tried this solution and would be glad to provide any further help you may need in this regard.

With best regards,

SanganakSakha,
Your Friend In Need

This discussion is closed to new replies.