Expiry of an open document

[Paul Anderson]

Hi There,

We have a problem where I work where we regularly use an
Excel spreadsheet but sometimes someone will leave it open
on their computer and no-one else can save to it.
Is there some sort of expiry that can be set? I was
thinking along the lines of after, say, 30 minutes the
open file on the computer changes to a read only document
so someone else can open and edit the dicument.

Thanks
Paul

 

[hcj]

Hi Paul,
Make repeat offenders take everyone out to lunch !

Seriously, I don't know of a way in Excel to do what
you suggest; perhaps one of the real gurus can help.