+ 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,767

    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?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ 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. [SOLVED] 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