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 to open a busy file.

Figure 25-1. The File In Use dialog box appears when you try to open a busy file.

If you click Notify in the File In Use dialog box, Excel opens your file in read-only mode and then alerts you when the file becomes available for read-write access by displaying the File Now Available dialog box shown in Figure 25-2.

Figure 25-2. The File Now Available dialog box alerts you when the file is no longer in use.