Friday, May 1, 2009

Daily Tips and Tricks Special Delivery

Tips and Tricks Special Delivery
Making tomorrow more productive than today
For Microsoft Office Excel 2007
Microsoft Office Excel 2007
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.


.
For the 2007 Microsoft Office system
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.

The 2007 Microsoft Office system

Quick Links
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
Microsoft

Your cOmment"s Here! Hover Your cUrsOr to leave a cOmment.


Subscribe to: Post Comments (Atom)