Sharing

[Robert Couchman]

Hello everyone,

Please can somebody help?

i am looking for a way that i can share my workbook
between lots of users.
i want many people to use the workbook at the same time,
but i want each persons data to be merged together.
is there any way of doing this?
if so, does it need VB code?

thank you,

Robert Couchman

 

[Jan Karel Pieterse]

Hi Robert,

i am looking for a way that i can share my workbook
between lots of users.
i want many people to use the workbook at the same time,
but i want each persons data to be merged together.
is there any way of doing this?

There is a way (Data, share workbook), but I would strongly advise
against it. Excel is not the proper program to use for sharing data
between multiple users, you should use Access for this.

Excel shows many problems with shared workbooks, which include crashes
and loss of data!

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com