Use lsof to discover what has the workbook open.
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.
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 … To get the ebook for free, visit this giveaway pageset by TradePub.Įnter your email address, then click “Download”įill out the form by putting in your name, email address, or Linkedin account information, and then click “Download.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.
This includes formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and doing statistical functions. From basic Excel functions like creating and editing worksheets to sharing and reviewing worksheets and editing macros with Visual Basic, it covers a wide range of the most common Excel applications and functions. It has been completely updated to reflect the big changes that Microsoft is making to Office 2019 as a whole. Now for a limited time, it’s available for free, that is till June 23, 2022.Įxcel 2019 All-In-One For Dummies is like eight books in one. Microsoft Excel 2019 For Dummies is an eBook from Wiley that normally sells for USD $29.99.