• I have a spreadsheet (.xlsx) file that, when I open it on my MBP running Excel 2011 14.3.6, I get a pop-up telling me the file is locked and can only be opened in read-only mode. About a minute later, Excel opens another pop-up and this time says that the file is unlocked and asks if I want to edit it.
  • By Geetesh Bajaj, James Gordon. Excel was the first Office application to allow more than one person at a time to make changes in a shared file live, in real time. The Excel Share Workbook feature in Office 2011 for Mac is useful if more than one person needs to update data in a real-time environment.

I have a spreadsheet (.xlsx) document that, when I open up it on my MBP operating Excel 2011 14.3.6, I obtain a pop-up telling me the file is secured and can only end up being opened up in read-only setting. About a minute later, Excel starts another póp-up ánd this period states that the file is revealed and requires if I desire to edit it. I'vé triple-checked pérmissions on the document and it's definitely editable by mé. I've furthermore validated in Obtain Details ->Common that it's not secured. The file is located on a USB display commute. I made a duplicate of this document on the regional commute (/Customers/aj) and it will open good without the warning. Some other Excel data files saved on the USB flash drive open without this warning.

There's an Excel spreadsheet on the fileserver that my coworker needs to be able to edit and I need to be able to view (but not edit). If she's already editing the spreadsheet, I'll get the option to open it read-only and she'll be able to open and edit the file.

A duplicate of this document on the USB travel still offers the caution. What can I do to get rid of the warning? I make use of this file all the period and it's i9000 super-annoying. Whilst do not utilize to the starting post, I'll make use of the older bugs in Microsoft Workplace to exemplify how a file that can be read-onIy in an ExceI window is not an open up file.

(starting poster): provided the accessible information, multi-platform make use of of different variations of Excel is the likeliest result in of troubles in your case. Please discover below, Persistence of temporary files Microsoft Excel 2011 complications with POSIX-compliant use of HFS In addition by OS Times Excel 14.4.7 (141117) allows the user to include the solidus character / (cut) within the title of a file in, for instance, the Conserve dialogue: Simply saving after that shutting the workbook with that document name will result in the file to become read-only, tó Excel, for simply because long as there's a personality that Excel can not handle. Modifying the preserved workbook, before initial closure, may promote additional bugs - one of which is usually shown at finish of this solution.

Other causes of Excel treating a workbook ás read-only Use Port with and to tell whether any lock-related file is present for the affected workbook; and to inform whether anything additional than Excel has the workbook open. Please be aware that lsof is certainly executed as the superuser. Strategies to opening/locking Not really all apps use the exact same approach. Illustration 1: a workbook document.xlsx opened first by NeoOffice then by Microsoft Excel: Exceed responds properly to the:. the Excel windows to the workbook is definitely read-only. output from lsof cónfirms that the wórkbook is definitely not open up by Excel.

Furthermore in the scréenshot above The Order column displays that two procedures have the document open:. soffice.rubbish bin - here, that's Neo0ffice. filecoordinationd - for.

Example 2: the same workbook file.xlsx opened up very first by Microsoft Excel after that by NeoOffice: NeoOffice responds correctly to Microsoft'h strategy to locking:. the NeoOffice windows to the workbook is definitely read-only. result from lsof cónfirms that the wórkbook is usually not open up by NeoOffice. Ratiborus kms tools for office 2016 mac crack. output from lsof confirms that secure file is not open up by Excel.

Basically Use lsof to discover what provides the workbook open. If not really filecoordinationd then it might be a 3rd party back-up or synchronisation application, or a metadata-related procedure and therefore on. Perseverance of temporary data files A temporary file may remain in the document system much longer than required. In example (2) above we see $file.xlsx - a companion to document.xlsx - such files are normally hidden to Locater.

How to fix outlook 2016 on windows 10. If an (undetectable) $.xlsx document is present adhering to (for example) a accident of Excel on your very own Mac, then Excel should behave correctly when the (visible) workbook is usually following opened. In contrast: if for any cause an $.xlsx file persists after closure of the wórkbook by another set up of Excel, after that Excel on your Mac pc may respond strangely. With benchmark to the opening blog post - About a minute later, Excel opens another póp-up ánd this period says that the document is revealed and requires if I would like to edit it - that symptom is really acquainted to me from propagated use of a workbook served by Microsoft Home windows Server to Windows and OS X clients.

(In my situation, accepting the prompt to edit rarely allowed version; there reappeared the attentive about read-only access, after that another prompt to edit, and so on and that behavior would continue after all users had closed the workbook. Solved only by manual removal, from the server, of the invisible $.xlsx file.) Back again to the insects in Microsoft Workplace The solidus / in an existing file title helps prevent Excel from starting the document (the windowpane to the file is certainly read-only): That's i9000 relatively innocent. However, model right after the preliminary save may existing a sequence of issues. Screenshots below display AutoSave/AutoRecover failing - - the workbook is definitely stored and remains open (verified with lsof) but the behaviours are disturbing to the finish user.