Open file on network share not locking when accessed by OpenOffice Calc 3??

I am suddenly experiencing an issue in which users in a WinXP workgroup are able to simultaneously access & edit .xls spreadsheets stored on a network share. Excel used to lock one user out from editing. I realized that one of the users has been using OpenOffice Calc v3. Could this be the reason both can open & edit the sheet??
bcalder123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

patrickabCommented:
bcalder123,
>Could this be the reason both can open & edit the sheet?
Yes. You most probably now have a corrupted copy of the file. This is my take on 'sharing' Excel files:
Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.
 
To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.
 
For Office 2007:  Office Button > Excel Options >Popular tab >User name
I realise it's not the message you really want, but I do hope it helps.
Patrick
0
patrickabCommented:
bcalder123,
Additionally I don't believe it's wise to use both Excel and Open Office on the same workbook. They are not totally interchangeable applications and the small differences may cause problems.
Try the Open and Repair option - it's the dropdown at the end of the file Open button. Most people completely ignore that dropdown and some even claim it's not there! Give it a try - for repairing the file.
Patrick
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bcalder123Author Commented:
Thanks patrickab. Luckily there's no file corruption. Your suggestion for tracking down the person with the file opened is excellent!
0
patrickabCommented:
bcalder123 - Thanks for the grade - Patrick
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
LibreOffice

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.