Microsoft® Excel® 2010 Inside Out

Saving and Retrieving Files on Remote Computers

By clicking the File tab and then clicking Save As, you can use the list at the top of the Save As dialog box to save a workbook on any available network drive, on a File Transfer Protocol (FTP) server, in a Web folder on the Internet, or on a Microsoft SharePoint site. The dialog box you see when you click the File tab and then click Open contains a similar list. You can use this list to retrieve workbooks saved on the network or on the Internet.

When you try to open a file that resides on a network drive while another user has the file open, Excel 2010 displays a dialog box that allows you to open the file in read-only mode. Figure 25-1 shows the File In Use dialog box that appears when you attempt ...