December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...