The main problem associated with this functionality is that once you have
shared the workbook then a number of options associated with formatting are
removed e.g. merging cells. If you want to make structural changes then you
have to untick the shared option which means people temoprarily may not be
able to access the workbook. For inexperienced users this may be a problem.
My advice is to build the workbook, make sure you are happy with it and then
share it - don't share too soon. The only other slight downside is that
inexperienced users may not be quite certain about the questions/prompts they
receive when other people edit the workbook.

Apart from this I haven't had any issues using the shared functionality and
it saves a lot of messing about with copy/paste.

Ian

"plngarbage" wrote:

Reading the Excel help I see that the conflict only occurs if two users make
a change to the same cell. Very smart.

"plngarbage" wrote:

Hi Ina.
That sounds like a great way to do this, I will have to play around with it.
When separate people have the file open and are updating different tabs, and
then save the file will they get the prompt about conflicts or only if they
are editing the same tab? My concern- we have some people who aren't
experienced computer users.