#EXCEL FOR MAC REMOVE READ ONLY MAC OS X#
#EXCEL FOR MAC REMOVE READ ONLY PLUS#
#EXCEL FOR MAC REMOVE READ ONLY WINDOWS#

#EXCEL FOR MAC REMOVE READ ONLY WINDOWS#

– that symptom is very familiar to me from shared use of a workbook served by Microsoft Windows Server to Windows and OS X clients. … 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 … In contrast: if for any reason an ~$….xlsx file persists after closure of the workbook by another installation of Excel, then Excel on your Mac may respond strangely.

If an (invisible) ~$….xlsx file is present following (for example) a crash of Excel on your own Mac, then Excel should behave properly when the (visible) workbook is next opened. In example (2) above we see ~$file.xlsx – a companion to file.xlsx – such files are normally invisible to Finder. If not filecoordinationd then it might be a third party backup or synchronisation application, or a metadata-related process … and so on.Ī temporary file may remain in the file system longer than necessary. Use lsof to discover what has the workbook open. output from lsof confirms that lock file is not open by Excel.output from lsof confirms that the workbook is not open by NeoOffice.the NeoOffice window to the workbook is read-only.NeoOffice responds properly to Microsoft's approach to locking: filecoordinationd – for system-wide file access coordination.Įxample 2: the same workbook file.xlsx opened first by Microsoft Excel then by NeoOffice:.The COMMAND column shows that two processes have the file open: output from lsof confirms that the workbook is not open by Excel.the Excel window to the workbook is read-only.

#EXCEL FOR MAC REMOVE READ ONLY MAC OS X#

Approaches to opening/lockingĮxample 1: a workbook file.xlsx opened first by NeoOffice then by Microsoft Excel:Įxcel responds properly to the Mac OS X native file locking of NeoOffice: Please note that lsof is executed as the superuser. Use Terminal with ls(1) and lsof(8) to tell whether any lock-related file is present for the affected workbook and to tell whether anything other than Excel has the workbook open. Other causes of Excel treating a workbook as read-only Simply saving then closing the workbook with that file name will cause the file to be read-only, to Excel, for as long as there's a character that Excel can not handle.Įditing the saved workbook, before initial closure, may expose additional bugs – one of which is shown at end of this answer.

#EXCEL FOR MAC REMOVE READ ONLY PLUS#

Microsoft Excel 2011 problems with POSIX-compliant use of HFS Plus by OS XĮxcel 14.4.7 (141117) allows the user to include the solidus character / (slash) within the name of a file in, for example, the Save dialogue: Please see below, Persistence of temporary files … Whilst the first answer did not apply to the opening post, I'll use the old bugs in Microsoft Office to exemplify how a file that is read-only in an Excel window is not an open (opening poster): given the available information, multi-platform use of different versions of Excel is the likeliest cause of problems in your case.

Excel for mac remove read only