Hi,



I don't believe so.
Workbook sharing, (which personally I don't rate very highly because it creates more problems than the limited benefits it offers), needs two or more users to be using the same instance of the workbook.

Your best solution would be to ensure that the data entered by the other user is readily identifiable and structured logically so that you can then use standard excel techniques to compare the two workbooks.

Regards

There is a compare and merge function in excel where you can compare and merge two shared workbook, as long as one of the workbooks derived from the other.

So if you take your shared workbook and send a copy to the other user(s), once you get their copy back, you can compare and merge the copies with yours.

Note that this only works with shared workbooks.

Unless I'm horribly mistaken I don't think that's correct. I don't believe you can take two completely independent copies of the same workbook, give them to two users remote from each other and expect to be able to merge them when they are returned.

Workbook sharing implies sharing the same workbook on a network - see the MS article http://office.microsoft.com/en-us/ex...001013057.aspx

Of course it only works with shared workbooks as you said, that's the whole point. The operative word is 'shared' (implicitly on a server). Merging, in the sense of bringing together completely separate instances of the workbook does not apply.

Regards