TCP/IP and Excel

P

Pyball

Working with Excel 2000 and Win NT 4.0

Is there a way, maybe through API's, that I can enter data into m
workbook on my computer then have that data sent to another compute
over the internet and have it displayed in there workbook?

Basically I want to be able to have numerous people working with thei
own identical workbooks and have one sheet that displays the same dat
for everyone.

I have read through many books and searched the internet but haven'
been able to come up with anything
 
R

Rob van Gelder

Look at storing a central database, then use the External Data feature of
the Data menu
 
F

Frank Kabel

Hi
not really feasible with Excel. Though Excel suppports sharing
workbooks ('Tools - share') I'd recommend to solve this with a database
solution. You have to deal with the issue sccessing this database via
Internet.

for reporting purpose you may connect Excel to this database (using
'Data - Import External Data')
 
P

Pyball

Rob, Frank,

Thank you for your replies.

The central database is a feasable option. The only question now is ho
to connect to that database via the internet
 
Top