Daily Tips and Tricks Special Delivery

Sign up for other newsletters | Unsubscribe | Update your profile Managing All External Data Source Connections With a Microsoft Office Excel workbook open, click the Data tab, and then click Connections. You can then view the data sources used in the workbook. If you select one, you can also see where that connection is used by clicking the Properties button. This feature is especially helpful when working with online analytical processing (OLAP) cubes via Excel. Check for Hidden Content Before Sharing Your Documents The 2007 Microsoft Office system programs Word, Excel, and PowerPoint include a new built-in Document Inspector tool that enables you to search for and remove potentially private hidden content before sharing your documents. To access the Document Inspector, first save your document. Then, click the Office button, point to Prepare, and then click Inspect Document. Depending on the program you are using, this tool searches for different content types—such as comments, unresolved tracked changes, and headers and footers in Word 2007. Of course, just because the tool finds relevant content (such as headers and footers) doesn't mean you should remove that content. The Document Inspector finds content that may be hidden depending upon the individual document's settings or the way you view the document. Review for yourself the content found by the tool to determine if you want to remove it from your document. Keep in mind that some types of content the Document Inspector finds (such as custom XML data) may be required for the document to function properly. • 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 © 2009 Microsoft Corporation Terms of Use | Trademarks | Privacy Statement