/build/static/layout/Breadcrumb_cap_w.png

Excel document won't lock down

I have come across multiple articles about how there will seem to be a phantom lock on a document (network shared) by another user. I'm having the opposite problem. I have a shared excel document that doesn't show locked by any users when multiple users have it open. This is creating problems when another user overwrites another user's work. None of the document protection settings are turned up, and this wasn't a problem as of a couple weeks ago. The behavior I expect to see when a user opens a document that's already opened by another user is that they will get the locked for editing message. This does not happen. I haven't been able to find a specific article that addresses this problem, so I'm looking to the all-wise IT Ninjas community for advice. Thank you in advance for your suggestions!


0 Comments   [ + ] Show comments

Answers (1)

Posted by: EdT 9 years ago
Red Belt
3
http://www.peersoftware.com/support/knowledgebase/item/peerlock-file-locking-does-not-work-on-a-windows-2008-r2-server.html
http://answers.microsoft.com/en-us/office/forum/officeversion_other-excel/file-locking-not-working/64832170-b659-4825-82e3-1f4b48380182
There were quite a few hits when I googled on "excel file not locked when in use". 
There are various opinions - one suggests it's a server issue, but also one user reports this problem went away when the workstations were all migrated to the same windows O/S.

Comments:
  • Just so you know, your first link is for a proprietary product called peer lock. Your second article is better. The best answer I got from sorting through it is that Windows XP may not create a temp file when the document is opened that would initiate the file lock. Windows 7 will do this and the recommended solution is to upgrade the operating system. - GeekSoldier 9 years ago
    • Just so you know, I only skip read the hits that google throws up. Since you were unable to find anything to help with your query, I was just introducing you to Google and the search string I used to find a couple of probably matches. ;-) - EdT 9 years ago
      • Much appreciated, thank you! - GeekSoldier 9 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ