Chapter 11Connecting Worksheets and Workbooks

Connecting Two Worksheets

Excel in Practice: Seeing Two Worksheets of the Same Workbook Side by Side

In Chapter 7, “Understanding Functions,” and Chapter 8, “Using Everyday Functions: Math, Date and Time, and Text Functions,” you find out how to set up formulas that calculate based on values within one worksheet. You can also easily connect a worksheet to several other worksheets or connect various workbooks. Excel 2019 offers easier-than-ever ways to connect a worksheet to data from the Web, data from text files, or data from databases such as Access.

In this chapter, you discover how to do the following:

  • Connect two worksheets

  • Connect two workbooks

  • Manage links between workbooks

Connecting ...

Get Microsoft Excel 2019 Inside Out 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.

Start your free trial