I have Excel 2010. I am experiencing situations where people leave work for the day and leave an Excel workbook on a shared file server open exclusively; as a result, other users are unable to edit the workbook. How can I mitigate this problem?
The recommended solution to your problem is to allow multiple users to edit the Excel spreadsheet at the same time. See About shared workbooks in the Excel help for details. The crux of this approach is to go to the Review tab in Excel's Ribbon, then click the "Share Workbook" button under the "Changes" section.
By all means, attempt to use the "Shared Workbooks" feature as a primary solution. Only read further if you have already tried Shared Workbooks and you are unable to get it to satisfy your needs.
If that won't work in your situation for some reason (certain workbook features aren't compatible with shared workbooks), try this VBA solution: