ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sharework book problems (https://www.excelbanter.com/excel-discussion-misc-queries/52535-sharework-book-problems.html)

genuinegal

Sharework book problems
 

Hi again,

My team of 30 regularly uses a Excel spreadsheet in which they all have
shared access, however, nearly everyday the file displays an error
message:

'File is locked'

Is there anyway i can prevent this from happening, or is it just a case
of the persistant access by all users that causes this error message?

When this error message occurs, the team all have to come out of the
file completely and go back in again...

Your help is appreciated, thanks!

GG :)


--
genuinegal
------------------------------------------------------------------------
genuinegal's Profile: http://www.excelforum.com/member.php...o&userid=28389
View this thread: http://www.excelforum.com/showthread...hreadid=479780



All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com