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

Posted on 2008-11-13
Last Modified: 2013-12-27
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??
Question by:bcalder123
    LVL 45

    Expert Comment

    >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.
    LVL 45

    Accepted Solution

    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.

    Author Closing Comment

    Thanks patrickab. Luckily there's no file corruption. Your suggestion for tracking down the person with the file opened is excellent!
    LVL 45

    Expert Comment

    bcalder123 - Thanks for the grade - Patrick

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free camera licenses with purchase of My Cloud NAS

    Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    Join Greg Farro and Ethan Banks from Packet Pushers ( and Greg Ross from Paessler ( for a discussion about smart network …
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now