The Select locked cells and Select unlocked cells options are selected by default so that Excel users can only select, but not edit, the function cells. You can select further options there so that spreadsheet users can still apply formatting changes or add hyperlinks to the formula cells. Microsoft Office document is “locked for editing by 'another user'” 11 answers I'm opening an Excel file and I'm getting the File in use pop-up that says it's locked for editing by me. However, I've not got it open on this computer (I think I had it open and my machine blue-screened).
Use MDO File Locking when you are sharing an Excel spreadsheet with others. A file lock is used to prevent two people from opening and updating the same spreadsheet at the same time, resulting in one person’s updates wiping out the other’s. File Locking is available for Excel in the My Docs Online, which works with all versions of Windows and Mac OS X, all versions of Microsoft Office Excel, and other spreadsheet applications such as OpenOffice.
To use the Desktop App for follow the following steps:. Select the Excel spreadsheet you have previously uploaded to My Docs Online and click “Lock & Open”. The spreadsheet will be locked on the MDO servers, downloaded to your PC or Mac, and opened for editing. After completing your editing Save & Close the spreadsheet in Excel.
![]()
In the Desktop App Click “Save & Unlock” for the document. Your changes will be uploaded to the MDO servers and the spreadsheet will be unlocked. The date and time for the file will be updated If you change your mind and need to discard your changes right-click the file in the Desktop App and select “Unlock without Saving”. The WebDAV protocol used by also supports File Locking for Microsoft Excel, including Windows XP, Windows Vista 32-bit Editions, and Windows 7, and Office 2003, 2007, and 2010. The latest combination of Windows and Office 2010 is less reliable than previous versions of Windows and Office.
![]()
The Desktop App and Web Folders can work in combination. For instance if one user opened an Excel spreadsheet with Web Folders a Desktop App user would not be allowed to Lock and Open the same file at the same time.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |