I have a workbook on a network drive that more than 1 person uses. If the
workbook is open to more than 1 person at the same time, how can it be
updated in real-time so that each can see what has been input?
Also how can I get round having to save it under a different name? If one
exits excel then the prompt is to save, but when you do, it requests that it
is saved with a different name.
What is worrying is that it is updated, the last person saves, but the other
persons data isn't. One file becomes read only.
Any suggestions please.

Bryan.