Hi
When all those users must enter data into same file, then there is nothing
to do. Migrate to Access!
When you can split your data so, that every part is edited by one user only,
then it's possible.
1. Create for every user his own excel workbook.
2. When some data must be accessible for all users, but one user is
administring those data, then in other workbooks use links to access them.
Links are refreshed whenever user opens his workbook - and you can write a
procedure (invoked through short-key, or command button implemented into
worksheet) to refresh them manually also.
3. When some user needs summary info from other workbooks, use links to
collect it again.
By such design, every user can access his/her data whenever he/she likes. No
messages about another user anymore. You can use diferent designs for
diferent users, and you have full control over data different users will
see.
--
(Don't use my reply address - it's spam-trap)
Arvi Laanemets
eric said:
There are around 30+ users sharing this one particular excel file. We are
located in different buildings and scattered all over the places. There is
one file that we all have to share in the network. Is there a way to let
the current user that have the file open to realized there are others
waiting to open the file and make changes. I know that if the file is
already open, others can only do a 'read only' and prevents them from doing
a save. Sometimes the user that have the file open leaves for lunch and
forgets to close it for others to use. How can this problem be resolved?
