Sharing Excel worksheet?

Is there any way possible that I can put three separate
Excel spreadsheets on three separate computers and if one
makes a change on any one of the spreadsheets and saves
it, that it replicates on the other two. The same changes
happen on the other two?

wrote:
Is there any way possible that I can put three separate
Excel spreadsheets on three separate computers and if one
makes a change on any one of the spreadsheets and saves
it, that it replicates on the other two.


If this is truly a multi-user application in which 3 users need update
access to the same dataset at the same time then you should be using a
database such as Access.

Excel has had a "shared workbook" mechanism for some time, but I would
advise against using it. Person A only see changes made by other
people when A saves the workbook (oddly!). Shared workbooks do not
give the full functionality of Excel. A good number of things have
been seen to go wrong with shared workbooks. Professional Excel
developers don't use them.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Despite this warning, and it's a good one. If you must use Excel, you could
write a macro that copies the workbook to the other computers when you close
it and save the changes.

Try inserting code into this event:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
Excel.Range)
'copy workbook to other computers.
End Sub


"Bill Manville" wrote in message
...
wrote:
Is there any way possible that I can put three separate
Excel spreadsheets on three separate computers and if one
makes a change on any one of the spreadsheets and saves
it, that it replicates on the other two.


If this is truly a multi-user application in which 3 users need update
access to the same dataset at the same time then you should be using a
database such as Access.

Excel has had a "shared workbook" mechanism for some time, but I would
advise against using it. Person A only see changes made by other
people when A saves the workbook (oddly!). Shared workbooks do not
give the full functionality of Excel. A good number of things have
been seen to go wrong with shared workbooks. Professional Excel
developers don't use them.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup