O'Reilly logo

Special Edition Using Microsoft® Office Excel® 2007 by Bill MrExcel Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 28. Connecting Worksheets, Workbooks, and External Data

In this chapter

Connecting Two Worksheets 798

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

Managing Connections 818

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required