Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sharing | Excel Discussion (Misc queries) | |||
Sharing | Excel Worksheet Functions | |||
Sharing | New Users to Excel | |||
Sharing | Excel Worksheet Functions | |||
When Sharing | Excel Discussion (Misc queries) |