How to use File Locking with Excel

Date: January 30th, 2011 | Category: Desktop App, File Locking, File Sharing, Webfolders / WebDAV

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 Desktop App, 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 File Locking follow the following steps:

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 Web Folders 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.

Try My Docs Online Free Today. No Credit Card Required.

Article published on My Docs Online FAQ - http://faq.mydocsonline.com

Print this article!