Excel file on network not giving users Read-only copy

[sawedoff]

We have several files in a shared folder on the network. A new Excel worksheet (2003) has just been saved in that folder, and even though it is set up the same as the others (as far as we can tell) it allows several users in at the same time but does not give anyone the File in use message, and allows them to edit the file even though it is open by another user at the same time. It is not set up in Excel to be shared by all. All users have Excel 2003.

Anyone have any ideas? Thanks in advance.

Sawedoff

 

[GlennUK]

What happens if 2 users make different changes simultaneously? Does one user lose their changes, or do both sets of changes get accepted?

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[sawedoff]

Whoever saves first wins, and the one who lags behind is notified that the file has been saved by another user, and asked if they want to disgard the replace the previous user's revisions with their own.

Hardly a suitable option. Somebody loses... Thanks for any help you can give.

Sawedoff

 

[AnotherHiggins]

-> It is not set up in Excel to be shared by all.

That sounds like a shared file. So just to confirm, the file name at the top doesn't have [Shared] beside it and the box isn't check in Tools > Sharing, right?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[sawedoff]

No, that's the odd thing. It doesn't say shared, and the box under Tools > Share Workbook is not checked. We have found that if one of the users (only three have right to the folder) opens it first, the others get the Read-only message. But if either of the others opens it first, nobody gets the message. I'd chalk it up to user error except that all three of them share several other worksheets in the same folder.

Thanks.

Sawedoff