Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile 2003 to 2007 Excel Services Microsoft Office Excel 2003 lists are called tables in Microsoft Office Excel 2007. Just as you can convert a data range to a list in Excel 2003, you can format a data range as a table in Excel 2007 by using the Format as Table command in the Styles section of the Home tab. Excel 2003 lists can be published to Windows SharePoint Services 2.0 sites and viewed in Windows Internet Explorer, so that you can share your data with others without having to share your entire worksheet. With Excel 2007 and Microsoft Office SharePoint Server 2007, you can publish Excel tables to Excel Services, so that you can share Excel information through the browser by using Microsoft Office Excel Web Access. Excel Web Access presents the information in an Excel-like view rather than the list view of Windows SharePoint Services 2.0. This view enables the people you are sharing with to work in a familiar environment, even manipulating certain sets of data in the browser, without having access to any proprietary information contained in other parts of the worksheet. To publish an Excel 2007 table to Excel Services, you must first save the worksheet to a Windows SharePoint Services 3.0 document library. Here's how: 1. Open the online file, click the Office button, and point to Publish. 2. Click Excel Services, and then click Excel Services Options. 3. On the Show tab, click the drop-down arrow, click Sheets, and then select the individual sheets that you want to publish. 4. Click OK, and then save the file. Create Multiple Calendars for Different Purposes In addition to the default Microsoft Office Outlook calendar, you can create other Outlook calendars. You might want a separate calendar for your personal appointments, for example. To open a new calendar: 1. On the File menu, point to New, and then click Folder. (There's a keyboard shortcut for this too: CTRL+SHIFT+E.) 2. In the Create New Folder dialog box that appears, type a name for the folder in the Name box. 3. In the Folder contains list, click Calendar Items. 4. In the Select where to place the folder list, select Calendar, and then click OK. • Tips and Tricks Web site • Microsoft Office Online • Help Privacy note: Microsoft respects your privacy and that of your friends. Please do not use the Tell a Friend button to send mail to more than 10 people. Microsoft cannot collect any data about the people you send mail to unless they sign up for Tips and Tricks Special Delivery. To cancel your subscription to this newsletter, reply to this message with the word "unsubscribe" in the subject line. You can also unsubscribe at the Microsoft.com Profile Center. You can manage all your Microsoft.com communication preferences at this site. Legal information Microsoft Corporation One Microsoft Way Redmond, WA 98052 Sign up for other newsletters | Unsubscribe | Update your profile © 2008 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement