Chapter 28. Connecting Worksheets, Workbooks, and External Data
In this chapter
Connecting to a Worksheet in Another Workbook 800
Connecting to Data on a Web Page 805
Setting Up a Connection to a Text File 809
Setting Up a Connection to an Access Database 812
Setting Up SQL Server, XML, OLE DB, and ODBC Connections 813
In Chapters 20, “Understanding Formulas,” and 21, “Controlling Formulas,” you learned how to set up formulas that calculate based on values within one worksheet. It is also very easy to connect a worksheet to several other worksheets or to connect various workbooks. Excel 2007 offers easier-than-ever ways to connect a worksheet to data from the Web, data from text files, or ...
Get Special Edition Using Microsoft® Office Excel® 2007 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
