excel doesnt allow exclusive user to save

[adrianlewis]

I have an excel spreadsheet that a number of people use but due to its nature we dont allow shared access so users must select notify if another user is currently in the sheet.

When a user selects notify after a period of time the notification arrives and allows the user access to edit even though the original user in edit mode is still in the sheet. When the first user then tries to save a message appears declining the request so the changes cannot be saved.

The read/write rights are being passed to the second user on numerous occasions.

Any ideas why this is happening or how it could be stopped?

Thanks Adrian.

[David_Jones]

Are you sure that the oringinal user is not 'giving up' the file reservation?

I have chased down problems like this before, and eventually you find that the user 'did think that it was important enough to tell you'.

However, I have not come across your specific situation before.

HTH,

Alan.

[adrianlewis]

I have checked and they arent doing anything that appears to give up the read/write permissions

[David_Jones]

Hi Adrian,

I think I have to suggest that you visit the MS excel newsgroups.

The real excel gurus are there and if you problem is solveable, they will solve it:

nntp:\\news.microsoft.com\microsoft.public.excel

OR

news:\\news.microsoft.com\microsoft.public.excel

(I think).

David.

[adrianlewis]

cheers. will do