+ Post New Thread
Results 1 to 8 of 8
Windows Server 2008 R2 Thread, User can't open excel spreadsheet locked by themselves? in Technical; One of our users has shown me a problem that when she tries to open a spreadsheet in her own ...
  1. #1
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,548
    Thank Post
    517
    Thanked 56 Times in 50 Posts
    Rep Power
    29

    User can't open excel spreadsheet locked by themselves?

    One of our users has shown me a problem that when she tries to open a spreadsheet in her own docs it sometimes tells her that it is locked for for editing because she has it open!
    She isn't logged on anywhere else only the one machine. It's almost random but happen more if she has just been on the spreadsheet and then come out of it. Also every time she opens the spreadsheet and closes it, it always asks if she wants to save the changes even though she has done nothing to it!

    Has anyone seen this before?


  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    If her machine recently crashed/shut down/logged off while she was editing the document, the lock file might still be present in her documents or possibly the temp folder.

    Try clearing out her temp folder first, then look to see if there's a hidden file in the same folder as the spreadsheet called something like "~$example.xls" (where the original workbook is called "example.xls"), if so, delete it and try again.

  3. Thanks to LosOjos from:

    reggiep (30th January 2014)

  4. #3


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,628
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    Is she closing it down cleanly? I've seen it happen where Excel crashes out on computer A and the end-user moves to computer B only to be told the document is open elsewhere.

    Is she using the spreadsheet directly our generating/accessing/launching Excel via SIMS, Sage, or something? I've seen both hold a document open before now - there'll be a process in task manager for Excel, but unless the end-user looks for it they won't notice.

  5. Thanks to pete from:

    reggiep (30th January 2014)

  6. #4
    GeekyPete's Avatar
    Join Date
    Mar 2013
    Location
    In a cold dark server room.
    Posts
    339
    Thank Post
    23
    Thanked 78 Times in 59 Posts
    Rep Power
    26
    Are the spreadsheets in a shared area or her own folder? Do you have even momentary losses of connection?

  7. Thanks to GeekyPete from:

    reggiep (30th January 2014)

  8. #5
    clareq's Avatar
    Join Date
    Dec 2005
    Location
    Doncaster
    Posts
    692
    Thank Post
    52
    Thanked 188 Times in 124 Posts
    Rep Power
    86
    I've seen something similar when preview is enabled on their folders.

  9. #6
    reggiep's Avatar
    Join Date
    Apr 2008
    Location
    In the vast area of space and time
    Posts
    1,548
    Thank Post
    517
    Thanked 56 Times in 50 Posts
    Rep Power
    29
    Quote Originally Posted by clareq View Post
    I've seen something similar when preview is enabled on their folders.
    preview is enabled on her folder!

  10. #7
    simpsonj's Avatar
    Join Date
    Apr 2009
    Location
    Oxford
    Posts
    381
    Thank Post
    159
    Thanked 64 Times in 53 Posts
    Blog Entries
    8
    Rep Power
    21
    I've also had a similar issue when the Status bar is enabled. I'd also recommend turning off preview too!

  11. #8

    Join Date
    Jan 2009
    Location
    Northants
    Posts
    135
    Thank Post
    3
    Thanked 11 Times in 10 Posts
    Rep Power
    13
    Preview causes all sorts of file locking issues, we see it all the time.

SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2007] Word says the file is locked by a user, but names the wrong user!
    By AngryTechnician in forum Office Software
    Replies: 10
    Last Post: 12th January 2012, 12:45 PM
  2. Replies: 2
    Last Post: 5th February 2010, 08:47 AM
  3. Replies: 11
    Last Post: 23rd March 2008, 08:52 PM
  4. Replies: 2
    Last Post: 14th September 2006, 10:27 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •