+ Reply to Thread
Results 1 to 2 of 2

Shared Excel File - refuses to save/open without posing an issue - LOCK file issue

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Missouri, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Unhappy Shared Excel File - refuses to save/open without posing an issue - LOCK file issue

    So, I have a shared Excel file on a shared drive on my work PC:

    The file locked up today ("This operation cannot be completed" was displayed upon opening and "This file is locked" was displayed after attempting to access the Review tab (>> Share Workbook >> (uncheck) Allow changes by other users)) as well as when anyone tries to save the file in the same location with the same name.

    I moved the file (for the sake of explanation, lets use the name sicily.xlsx) to my local C: drive. From there, I unshared the file, reshared it, and saved the same file but with a different name (sicily1.xlsx) back to my Shared drive. It is no longer causing problems. When I tried to name sicily1 BACK to sicily, the program reverted back to its initial output status.

    I have located the file lockfile (~$Sicily.xlsx) that is residing in my shared drive since August 19, 2013. When I attempt to rightclick and delete the lockfile, nothing happens.

    Is there a way to delete this lockfile? Why is it refusing to respond to a simple delete command? Am I right by assuming this lockfile is the cause of my issues?

    Please let me know if you guys know of anything! Thank you so much!

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,766

    Re: Shared Excel File - refuses to save/open without posing an issue - LOCK file issue

    Just confirm what do you mean by Shared drive? Whether something in cloud or in server or network drive?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Shared File - Compatability Issue
    By domclarke in forum Excel General
    Replies: 1
    Last Post: 10-30-2012, 06:56 AM
  2. Replies: 4
    Last Post: 10-21-2012, 06:00 PM
  3. Formatting Issue with Shared Excel File
    By DamienR8 in forum Excel General
    Replies: 0
    Last Post: 10-23-2008, 10:28 AM
  4. excel open file issue warps spreadsheet
    By jasonlujan in forum Excel General
    Replies: 2
    Last Post: 07-26-2007, 03:39 PM
  5. File Lock issue
    By Clint in forum Excel General
    Replies: 2
    Last Post: 05-03-2006, 06:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1