Here's one for the techies unless a macro will do it.

  • Thread starter Thread starter Bryan De-Lara
  • Start date Start date
B

Bryan De-Lara

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.
 
Simon,
Thanks Simon,
Everyone who opens it will make changes and it all should be saved. How do I
set it up as a shared workbook?
 
Bryan said:
Simon,
Thanks Simon,
Everyone who opens it will make changes and it all should be saved. How
do I set it up as a shared workbook?
Click to expand...


You could try "About shared workbooks" in the help file.
 
When in help "about shared workbooks" also take note of the loss of
functionality in shared workbooks.


Gord Dibben MS Excel MVP
 
In view of your original question about multiple users working on the same
workbook simultaneously, I can see no other option than to share the
workbook.


Gord
 
Thanks Gord.
This thread is now closed.
Bryan.

Gord Dibben said:
In view of your original question about multiple users working on the same
workbook simultaneously, I can see no other option than to share the
workbook.


Gord
Click to expand...
 
Back
Top