+ Reply to Thread
Results 1 to 5 of 5

file locked for editing - read only

  1. #1
    Registered User
    Join Date
    03-03-2016
    Location
    Portland, OR
    MS-Off Ver
    Excel for Mac 2011 14.6.1
    Posts
    2

    Question file locked for editing - read only

    I have a worksheet I use constantly, and I'm the only user. I keep it on Dropbox so that it is accessible from both of my computers wherever I am. On one of my Macs (but not the other), I now get an error message that the file is "locked for editing - read only." If I click ok for read only, I quickly get a pop-up telling me the file has now been unlocked and I can open it for editing. If I click okay, the file shuts down completely. If I reopen it, it's the same process over again. I really need this file and I have no idea how it became corrupted. How do I fix this?

  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: file locked for editing - read only

    Try opening the file with the Mac that has no problem and save it locally under a NEW name.
    Delete the original file from Dropbox
    Upload file (with its new name) to Dropbox
    Download it and open it on the other Mac

  3. #3
    Registered User
    Join Date
    03-03-2016
    Location
    Portland, OR
    MS-Off Ver
    Excel for Mac 2011 14.6.1
    Posts
    2

    Re: file locked for editing - read only

    Thank you, I tried what you suggested and it's good -- for now. The problem isn't with the file, it's Excel on my Mac. It shut down unexpectedly when I opened the new file. But at least, for now, I have access to the file.

  4. #4
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: file locked for editing - read only

    Guessed that was the problem. Had similar issues. Locked files are a pain - something, somewhere has not been reset. Re-install of Excel on afflicted MAC will probably sort everything - and is easier than trying to work out where the problem is.

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: file locked for editing - read only

    Mac computers create temporary files when you use Excel (and other applications). Locate these temp files and delete them. If Excel crashed or otherwise shut down incorrectly, temp files could be left behind that could interfere with the running of Excel.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. If Excel File READ ONLY then ALL CELLS to be locked for editing (protected)
    By alimsab in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2015, 10:33 AM
  2. Replies: 0
    Last Post: 09-06-2013, 05:31 AM
  3. File is locked for Editing
    By retiredjhawk in forum Excel General
    Replies: 1
    Last Post: 08-23-2011, 02:24 AM
  4. File in use.. locked for editing
    By freekrill in forum Excel General
    Replies: 0
    Last Post: 12-01-2010, 06:55 PM
  5. if locked for editing message box comes up auto select read-only
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2009, 01:38 PM
  6. File Locked for editing--not
    By mike montagne in forum Excel General
    Replies: 1
    Last Post: 07-13-2005, 10:05 PM
  7. [SOLVED] File in use NOT locked for editing...
    By Mathieu Paquette in forum Excel General
    Replies: 0
    Last Post: 04-19-2005, 10:06 AM

Tags for this Thread

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