Sharing
 

Greetings Guys,

i have a shared excel file where nearly 20 people will be upating data on
regular basis, most often this file is getting locked like the file is lokced
by this user and even after the particular user close the file also it
remains as locked forever. Is there any way to avoid these kind of locking
issues.

thanks
raiju

Sharing
 

Raiju;276064 Wrote:
Greetings Guys,

i have a shared excel file where nearly 20 people will be upating data
on
regular basis, most often this file is getting locked like the file is
lokced
by this user and even after the particular user close the file also it
remains as locked forever. Is there any way to avoid these kind of
locking
issues.

thanks
raijuThat sounds like it isn't shared properly, normally when shared the only
warning you would get is if two people are making changes to the same
cell/range. It seems that although you have open access to your workbook
it isn't actually shared.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77045

Sharing
 

how do we check whether the file is really shared one or not

"Simon Lloyd" wrote:


Raiju;276064 Wrote:
Greetings Guys,

i have a shared excel file where nearly 20 people will be upating data
on
regular basis, most often this file is getting locked like the file is
lokced
by this user and even after the particular user close the file also it
remains as locked forever. Is there any way to avoid these kind of
locking
issues.

thanks
raijuThat sounds like it isn't shared properly, normally when shared the only
warning you would get is if two people are making changes to the same
cell/range. It seems that although you have open access to your workbook
it isn't actually shared.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=77045